JL Colombian Magnetic Media Literals and Third Party Movement - draft

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Colombian Magnetic Media Literals and Third Party Movement Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLCOGLNM_XML
DB package: JL_JLCOGLNM_XMLP_PKG
SELECT    
	  TO_CHAR(mglit.literal_code)	literal
	, DECODE(n.type, 'FOREIGN_ENTITY', '444444444', 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 
	--JL_JLCOGLNM_XMLP_PKG.cf_totalformula(:CS_rep_firstval, :CS_rep_secondval) CF_total
FROM
	  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.reported_flag	= 'Y'
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_START1 AND :P_LITERAL_END1
ORDER BY mglit.literal_code, n.nit
Parameter Name SQL text Validation
Ledger Id
 
Number
Literal End
 
LOV Oracle
Literal Start
 
LOV Oracle
Reported Year
 
LOV Oracle
Legal Entity
 
LOV Oracle