select
&FLEXDATA FLEXDATA_H,
&ACCOUNT_SEG ACCOUNT_SEG_H,
glbv.budget_name Dep_Bud_Name,
&PTD_YTD Dep_amount,
fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP,
fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP
FROM
gl_code_combinations cs,
gl_balances glbd,
gl_budget_versions glbv
where
glbd.ledger_id = :P_LEDGER_ID AND
glbd.currency_code = :P_CURRENCY_CODE AND
glbd.period_name = :P_PERIOD_NAME AND
glbd.actual_flag = 'B' AND
glbd.code_combination_id = cs.code_combination_id AND
glbd.budget_version_id in
(select glbv1.budget_version_id
from gl_budget_versions glbv1
where glbv1.control_budget_version_id =
:P_BUDGET_VERSION_ID) AND
glbd.budget_version_id = glbv.budget_version_id AND
NVL(glbd.translated_flag,'R') = 'R' AND
glbd.template_id is NOT NULL AND
glbd.code_combination_id NOT IN
(select glbc.code_combination_id
from gl_balances glbc
where glbc.ledger_id = :P_LEDGER_ID AND
glbc.period_name = :P_PERIOD_NAME AND
glbc.currency_code = :P_CURRENCY_CODE AND
glbc.budget_version_id = :P_BUDGET_VERSION_ID AND
glbc.actual_flag = 'B')
&WHERE_DAS
order by 1 ASC ,
&FLEX_ORDERBY,
glbv.budget_name |
select
&FLEXDATA FLEXDATA_H,
&ACCOUNT_SEG ACCOUNT_SEG_H,
glbv.budget_name Dep_Bud_Name,
&PTD_YTD Dep_amount,
fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP,
fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP
FROM
gl_code_combinations cs,
gl_balances glbd,
gl_budget_versions glbv
where
glbd.ledger_id = :P_LEDGER_ID AND
glbd.currency_code = :P_CURRENCY_CODE AND
glbd.period_name = :P_PERIOD_NAME AND
glbd.actual_flag = 'B' AND
glbd.code_combination_id = cs.code_combination_id AND
glbd.budget_version_id in
(select glbv1.budget_version_id
from gl_budget_versions glbv1
where glbv1.control_budget_version_id =
:P_BUDGET_VERSION_ID) AND
glbd.budget_version_id = glbv.budget_version_id AND
NVL(glbd.translated_flag,'R') = 'R' AND
glbd.template_id is NOT NULL AND
glbd.code_combination_id NOT IN
(select glbc.code_combination_id
from gl_balances glbc
where glbc.ledger_id = :P_LEDGER_ID AND
glbc.period_name = :P_PERIOD_NAME AND
glbc.currency_code = :P_CURRENCY_CODE AND
glbc.budget_version_id = :P_BUDGET_VERSION_ID AND
glbc.actual_flag = 'B')
&WHERE_DAS
order by 1 ASC ,
&FLEX_ORDERBY,
glbv.budget_name |
