JL Colombian Magnetic Media Literals, Accounts and Third Party Movement - draft

Description
Categories: BI Publisher
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 Name SQL text Validation
Legal Entity
 
LOV Oracle
Reported Year
 
LOV Oracle
Literal Start
 
LOV Oracle
Literal End
 
LOV Oracle
Ledger Id
 
Number