GL Budget - Summary/Detail

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Summary/Detail (XML)
Short Name: GLXBCSD_XML
DB package: GL_GLXBCSD_XMLP_PKG
select
  null FLEXDATA1_H,
  (nvl(bal.period_net_dr,0) - nvl(bal.period_net_cr,0))       	Detail_Bal,
  b.name                         				Batch_Name,
  h.name                         				Header_Name,
  l.je_line_num                   				Line_Num,
  h.posted_date                 				Header_Post_Date,
  decode(:P_CURRENCY_CODE,'STAT',
   decode(h.currency_code, 'STAT',
    decode(sign(nvl(l.stat_amount,0)), '1',
      nvl(l.entered_dr,0)+nvl(l.stat_amount,0),
      nvl(l.entered_dr,0)),
    decode(sign(nvl(l.stat_amount,0)), '1',
      nvl(l.stat_amount,0),0)),
   nvl(l.entered_dr,0)) 					Line_Debits,
  decode(:P_CURRENCY_CODE,'STAT',
   decode(h.currency_code,'STAT',
    decode(sign(nvl(l.stat_amount,0)),'-1',
     nvl(l.entered_cr,0)-nvl(l.stat_amount,0),
     nvl(l.entered_cr,0)),
    decode(sign(nvl(l.stat_amount,0)),'-1',
     abs(l.stat_amount), 0)),
   nvl(l.entered_cr,0)) 					Line_Credits,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata1_dsp', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA1_DSP
from
  gl_je_batches          					b,
  gl_je_headers          					h,
  gl_je_lines              					l,
  gl_code_combinations  				cc,
  gl_balances            					bal,
  gl_account_hierarchies 				hi
where
  b.status = 'P' 					AND
  b.actual_flag = 'B' 					AND
  b.je_batch_id = h.je_batch_id 				AND
  h.ledger_id = :P_LEDGER_ID 				AND
  h.period_name||'' = :P_PERIOD_NAME  			AND
  (h.currency_code = DECODE(:P_CURRENCY_CODE,'STAT',
                             DECODE(L.STAT_AMOUNT,NULL,'****',h.currency_code),:P_CURRENCY_CODE)
   OR h.currency_code = :P_CURRENCY_CODE) 		AND
  h.status = 'P' 					AND
  h.actual_flag = 'B' 					AND
  h.budget_version_id = :P_BUDGET_VERSION_ID 		AND
  h.je_header_id = l.je_header_id 				AND
  l.ledger_id = :P_LEDGER_ID 				AND
  l.status = 'P' 					AND
  l.period_name = :P_PERIOD_NAME 			AND
  l.code_combination_id = bal.code_combination_id 		AND
  cc.code_combination_id = hi.detail_code_combination_id 	AND
  bal.ledger_id = :P_LEDGER_ID 				AND
  bal.currency_code = :P_CURRENCY_CODE 			AND
  bal.actual_flag = 'B' 					AND
  bal.budget_version_id = :P_BUDGET_VERSION_ID 		AND
  bal.period_name = :P_PERIOD_NAME 			AND
  bal.code_combination_id = hi.detail_code_combination_id 	AND
  nvl(bal.translated_flag, 'R') = 'R'		 		AND
  hi.ledger_id = :P_LEDGER_ID 				AND
  hi.summary_code_combination_id = :SUMMARY_CODE_COMBINATION_ID
  &DAS_WHERE
order by
  &FLEX_ORDERBY,
  b.name,
  h.name,
  l.je_line_num
Parameter Name SQL text Validation
Chart of Accounts Id
 
Number
Access Set Id
 
Number
Period
 
LOV Oracle
Currency
 
LOV Oracle
Summary Account
 
Budget
 
LOV Oracle
Ledger
 
LOV Oracle
Ask a question