JL Colombian Magnetic Media Literals 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 and Third Party Movement Report
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
Run JL Colombian Magnetic Media Literals and Third Party Movement Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
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, Accounts 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 Third Party / Account Report- Not Supported: Reserved For Future Use JL Colombian Account / Third Party 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 Fixed Assets Inflation Adjusted Account Drill Down 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™

Blitz Report™ provides multiple benefits: