JL Brazilian Opening and Closing Pages

➜ Back to Library
Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Brazilian Opening and Closing Pages Report
Short Name: JLBRLOCP
DB package:
Run JL Brazilian Opening and Closing Pages and other Oracle EBS reports with Blitz Report™ on our demo environment
	 select
		A.NAME,  
		A.ADDRESS_LINE_1,		
		A.ADDRESS_LINE_2,
		A.ADDRESS_LINE_3,		
		A.TOWN_OR_CITY	,		
		A.REGISTRATION_NUMBER,	
		To_Char (fnd_conc_date.STRING_TO_DATE(A.EFFECTIVE_FROM), 'DD-MON-YY' ) EFFECTIVE_FROM ,			
		(select H.LOCATION_CODE from HR_LOCATIONS H where H.LOCATION_ID = A.LOCATION_ID ) LOCATION
	 from XLE_FIRSTPARTY_INFORMATION_V A , GL_LEDGER_LE_V G
	 where A.LEGAL_ENTITY_ID=  :P_LEGAL_ENTITY_ID
		and A.LEGAL_ENTITY_ID = G.legal_entity_id
		and G.LEDGER_ID =  :P_LEDGER_ID
Parameter Name SQL text Validation
JLBR_SRS_SET_OF_BOOKS 
 
 Number
Company 
 
 LOV Oracle
Daily / Ledger Flag 
 
 Char
Request Id 
 
 Number
Download
Related Blitz Reports
GL Ledgers and Legal Entities JL Brazilian Page Numbering Template JE Italian Withholding Yearly JL Colombian Payables Withholding Certificate - draft ZX Party Tax Profiles CE General Ledger Reconciliation ECC Projects, Projects Costing: Transactions, SQL1 orgs JE Belgian VAT Sales Journal
Blitz Report™

Blitz Report™ provides multiple benefits: