GL Budget - Unbudgeted Master/Detail Accounts

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Unbudgeted Master/Detail Accounts (XML)
Short Name: GLRRBUDA_XML
DB package: GL_GLXRBUDA_XMLP_PKG
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
Parameter Name SQL text Validation
Access Set Id
 
Number
Amount Type
 
LOV Oracle
Currency
 
LOV Oracle
Period
 
LOV Oracle
Master Budget
 
LOV Oracle
Ledger
 
LOV Oracle