GL Budget - Journals by Account

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Journals by Account (XML)
Short Name: GLXRBJRN_XML
DB package: GL_GLXRBJRN_XMLP_PKG
select
lo.description                 			Line_Status,
l.period_name              			Period_Name,
b.name                    				Batch_Name,
h.name                    				Header_Name,
l.je_line_num              			Line_Num,
l.description               			Line_Desc,
decode(:P_CURRENCY_CODE,
              h.currency_code, l.entered_dr,
              null)			 	Debits,
decode(:P_CURRENCY_CODE,
              h.currency_code, l.entered_cr,
              null)                 			Credits,
l.stat_amount 				Stat_Amount
from
gl_lookups                   			lo,
gl_period_statuses           			p,
gl_je_headers                			h,
gl_je_batches                			b,
gl_je_lines                    			l,
gl_code_combinations                                       cc
where
l.period_name in (select period_name
                      from gl_period_statuses
                      where application_id = 101
                      and   ledger_id =
                      :P_LEDGER_ID
                      and   period_year =
                      :P_PERIOD_YEAR)		AND
l.code_combination_id
   = :P_CODE_COMBINATION_ID  	 	AND
(h.currency_code = :P_CURRENCY_CODE     OR
   (:P_CURRENCY_CODE = 'STAT'   AND
    l.stat_amount IS NOT NULL))			AND
h.actual_flag = 'B'                       	     	AND
h.budget_version_id= :P_BUDGET_VERSION_ID AND
h.je_header_id=l.je_header_id            		AND
b.je_batch_id = h.je_batch_id              		AND
p.period_name = l.period_name              		AND
p.ledger_id = :P_LEDGER_ID 	AND
p.application_id = 101                      		AND
lo.lookup_type = 'MJE_BATCH_STATUS'      	AND
lo.lookup_code = substr(b.status, 1, 1)         AND
cc.code_combination_id = :P_CODE_COMBINATION_ID
&WHERE_DAS
order by
1,
p.period_num,
b.name,
h.name,
l.je_line_num
Parameter Name SQL text Validation
Chart of Accounts Id
 
Number
Data Access Set ID
 
Number
Year
 
LOV Oracle
Currency
 
LOV Oracle
Accounting Flexfield
 
Budget
 
LOV Oracle
Ledger
 
LOV Oracle