GL Journals - General(132 Char)

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

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