JL Colombian Magnetic Media Literals, Accounts and Third Party Movement Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Colombian Magnetic Media Literals, Accounts and Third Party Movement Report
Application: Latin America Localizations
Source: Colombian Magnetic Media Literals, Accounts and Third Party Movement Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLCOGLAM_XML
DB package: JL_JLCOGLAM_XMLP_PKG
SELECT    
	  TO_CHAR(mglit.literal_code)	literal
	, n.nit			nit
	, l.meaning			id_type
	, mgl.reported_value		reported_val
	, mgl.third_party_name	nit_name
	, mgl.first_reported_value	first_val
	, mgl.second_reported_value	second_val
	, mgr.range_line_num		line_num
	, &C_ACCOUNT_START 	ac_low 
	, &C_ACCOUNT_END 	ac_high
FROM
	  jl_co_gl_mg_ranges		mgr
	, jl_co_gl_mg_literals		mglit
	, FND_LOOKUPS		l
	, jl_co_gl_nits		n
	, jl_co_gl_mg_lines		mgl
	, jl_co_gl_mg_headers		mgh
WHERE
	mgh.set_of_books_id	= :P_SOB_ID
AND	mgh.reported_year	= :P_REPORTED_YEAR
AND	mgh.mg_header_id	= mgl.mg_header_id
AND	mgl.nit_id		= n.nit_id
AND	n.type		= l.lookup_code
AND	l.lookup_type	= 'JLCO_TAXID_TYPE'
AND	mgl.literal_id	= mglit.literal_id
AND	TO_CHAR(mglit.literal_code) 
		BETWEEN :P_LITERAL_START AND :P_LITERAL_END
AND	mgl.range_id	= mgr.range_id
ORDER BY  TO_CHAR(mglit.literal_code)
	, mgl.reported_value
	, mgr.range_line_num 
	, n.nit
Parameter NameSQL textValidation
Operating Unit
 
LOV
Legal Entity
 
LOV Oracle
Reported Year
 
LOV Oracle
Literal Start
 
LOV Oracle
Literal End
 
LOV Oracle
Download
Related Blitz Reports
JL Colombian Magnetic Media Literals and Third Party Movement Report- Not Supported: Reserved For Future Use JL Colombian Magnetic Media Literal Configuration Verification Report- Not Supported: Reserved For Future Use JL Colombian Account / Third Party Report- Not Supported: Reserved For Future Use JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Account Drill Down Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft JL Colombian Inflation Adjusted Fixed Assets Report- Not Supported: Reserved For Future Use JL Colombian Third Party Balances Error Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Technical Appraisal Additions - draft
Blitz Report™