GL Journals - (180 Char)

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Journals - (180 Char) (XML)
Short Name: GLGENJRN2_XML
DB package: GL_GLRGNJ_XMLP_PKG
SELECT 
S.user_je_source_name                  	Source, 
B.name 				Batch_Name,
B.default_effective_date 		Batch_Eff_date,
B.posted_date 			Batch_Posted_Date,
B.default_period_name		Batch_Period,
B.je_batch_id 			Batch_Id,
B.actual_flag 			Actual_Flag,
B.average_journal_flag		Average_Journal_Flag,
B.running_total_accounted_dr 		B_TOT_DR,
B.running_total_accounted_cr 		B_TOT_CR, 
D.je_header_id 			Header_id, 
D.name 				Header_Name, 
L.name 				Ledger_Name,
D.default_effective_date		Header_Eff_Date,
C.user_je_category_name 		Category,
D.currency_code 			Currency_Code, 
D.external_reference 		Header_Reference, 
D.running_total_accounted_dr 		H_TOT_DR,
D.running_total_accounted_cr 		H_TOT_CR,
J.je_line_num 			Je_Line_Num,
decode(nvl(CC.code_combination_id, -1), -1, 'A',null) FLEXDATA_H,
J.effective_date 			Line_Effective_Date, 
J.description 			Line_Description,
J.accounted_dr 			Line_Acc_Dr, 
J.accounted_cr 			Line_Acc_Cr,
&POSTING_STATUS_SELECT 		Reference1_4,
nvl(J.stat_amount,0) 		Line_Stat_Amount, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata_dsp', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA_DSP, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata_secure', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') FLEXDATA_SECURE
FROM  
gl_je_sources          			S,
gl_je_categories       			C,
gl_je_lines             			J, 
gl_code_combinations 		CC,
gl_je_headers 			D, 
gl_je_batches 			B,
&LEDGER_FROM
gl_ledgers 			L
WHERE
S.je_source_name = D.je_source 			AND
C.je_category_name = D.je_category 			AND
J.code_combination_id = CC.code_combination_id(+) 		AND
J.je_header_id = D.je_header_id 				AND   
&CURRENCY_WHERE 				AND
D.je_source = NVL(:P_JE_SOURCE_NAME, D.je_source) 	AND
(D.display_alc_journal_flag is null or D.display_alc_journal_flag = 'Y') AND
D.je_batch_id = B.je_batch_id 				AND
&POSTING_STATUS_WHERE 				AND
B.name = NVL(:P_BATCH_NAME, B.name) 		AND
&PERIOD_WHERE 					AND
&LEDGER_WHERE
L.ledger_id = D.ledger_id
&DAS_WHERE
/*ORDER BY 
  S.user_je_source_name,
  B.actual_flag,
  B.name,
  B.default_effective_date,
  L.name,
  D.name, 
  J.je_line_num*/
  order by Source,Batch_Name,Batch_Eff_date,Actual_Flag,Header_Name,Ledger_Name,Je_Line_Num
Parameter Name SQL text Validation
Pagesize
 
Number
Access Set Id
 
Number
Batch Name
 
LOV Oracle
Source
 
LOV Oracle
GL_SRS_STANDARD_DATE_HIGH
 
Date
GL_SRS_STANDARD_DATE_LOW
 
Date
Period
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle
Currency
 
LOV Oracle
Posting Status
 
LOV Oracle
Type
 
LOV Oracle