GL Journals - Entered Currency (132 Char)

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Journals - Entered Currency (132 Char) (XML)
Short Name: GLRFGNJ_XML
DB package: GL_GLRFGNJ_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.je_batch_id 					Batch_Id,
B.actual_flag 					Actual_Flag,
B.average_journal_flag				Average_Journal_Flag,
D.je_header_id 					Header_id,
D.name 						Header_Name,
L.name						Ledger_Name,
L.currency_code					Ledger_Currency,
C.user_je_category_name 				Category,
D.currency_code 					Currency_Code,
D.external_reference 				Header_Reference,
D.currency_conversion_date 				Conversion_Date,
GDCT.user_conversion_type 				Conversion_Type,
D.currency_conversion_rate 				Conversion_Rate,
J.je_line_num 					Je_Line_Num,
decode(nvl(CC.code_combination_id,-1),-1,'A',null) 	FLEXDATA_H,
J.effective_date 					Line_Effective_Data,
J.description 					Line_Description,
decode(d.currency_code, 'STAT', null,
  decode(sign(abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))),
       1, nvl(j.accounted_dr,0) - nvl(j.accounted_cr,0),
      -1, nvl(j.accounted_cr,0) - nvl(j.accounted_dr,0),
       0, decode(sign(abs(nvl(j.accounted_dr,0)) - abs(nvl(j.accounted_cr,0))),
          1, nvl(j.accounted_dr,0) - nvl(j.accounted_cr,0),
         -1, nvl(j.accounted_cr,0) - nvl(j.accounted_dr,0), 0)))	Accounted_Amount,
decode(sign(abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))),
       1, nvl(j.entered_dr,0) - nvl(j.entered_cr,0),
      -1, nvl(j.entered_cr,0) - nvl(j.entered_dr,0), 0)		Entered_Amount,
decode((abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))),
                0, sign(abs(nvl(j.accounted_dr,0)) - abs(nvl(j.accounted_cr,0))),
                    sign(abs(nvl(j.entered_dr,0)) - abs(nvl(j.entered_cr,0))))	Dr_Cr,
&POSTING_STATUS_SELECT 				Recerence1_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,
	GL_GLRFGNJ_XMLP_PKG.dr_cr_dspformula(decode ( ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 0 , sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) )) DR_CR_DSP,
	GL_GLRFGNJ_XMLP_PKG.ent_x_drcrformula(decode ( ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 0 , sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) ), decode ( sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 1 , nvl ( j.entered_dr , 0 ) - nvl ( j.entered_cr , 0 ) , - 1 , nvl ( j.entered_cr , 0 ) - nvl ( j.entered_dr , 0 ) , 0 )) ENT_X_DRCR,
	GL_GLRFGNJ_XMLP_PKG.acct_x_drcrformula(decode ( ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 0 , sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) ), decode ( d.currency_code , 'STAT' , null , decode ( sign ( abs ( nvl ( j.entered_dr , 0 ) ) - abs ( nvl ( j.entered_cr , 0 ) ) ) , 1 , nvl ( j.accounted_dr , 0 ) - nvl ( j.accounted_cr , 0 ) , - 1 , nvl ( j.accounted_cr , 0 ) - nvl ( j.accounted_dr , 0 ) , 0 , decode ( sign ( abs ( nvl ( j.accounted_dr , 0 ) ) - abs ( nvl ( j.accounted_cr , 0 ) ) ) , 1 , nvl ( j.accounted_dr , 0 ) - nvl ( j.accounted_cr , 0 ) , - 1 , nvl ( j.accounted_cr , 0 ) - nvl ( j.accounted_dr , 0 ) , 0 ) ) )) ACCT_X_DRCR,
	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_daily_conversion_types		GDCT,
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
GDCT.conversion_type = D.currency_conversion_type 	AND
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
D.currency_code = :P_CURRENCY_CODE 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
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
Entered Currency
 
LOV Oracle
Posting Status
 
LOV Oracle
Type
 
LOV Oracle
Ask a question