hfm系統常見表查詢

以下SQL查詢FDMEE的定時任務：
select a., b.
from fdmee.SNP_PLAN_AGENT a,
(select b.i_plan_agent, b.var_name, b.var_value
from fdmee.SNP_VAR_PLAN_AGENT b)
pivot(max(var_value)
for var_name in('AIF.p_bal_import_from_source_flag' as source_flag,
'AIF.p_bal_check_flag' AS check_flag,
'AIF.p_prd_start_date' AS start_date,
'AIF.p_prd_end_date' AS end_date,
'AIF.p_bal_load_exch_rate_flag' AS exch_rate_flag,
'AIF.p_bal_recalculate_flag' AS recalculate_flag,
'AIF.p_web_service_url' AS service_url,
'AIF.p_bal_export_mode' AS export_mode)) b
where a.i_plan_agent = b.i_plan_agent
ORDER BY A.I_PLAN_AGENT;