JE UK Reverse Charge Sales List

Description
Categories: BI Publisher
Application: European Localizations
Source: UK Reverse Charge Sales List Report
Short Name: JEUKRSLR_XMLP
DB package: JE_REVERSE_SALES_LIST_PKG
				SELECT name LEGAL_ENTITY,
				       TO_CHAR(:P_FROM_DATE,'DD-Mon-YYYY') FROM_DATE,
				       TO_CHAR(:P_TO_DATE,'DD-Mon-YYYY') TO_DATE,
                       :P_TAX_REG_NUM||','||TO_CHAR(:P_FROM_DATE,'ddmmyyyy')||','||TO_CHAR(:P_TO_DATE,'ddmmyyyy') CS_HEADER
					     FROM xle_entity_profiles
						   WHERE legal_entity_id = :P_LEGAL_ENTITY
Parameter Name SQL text Validation
To Date
 
Date
From Date
 
Date
Tax Registration Number
 
LOV Oracle
Legal Entity
 
LOV Oracle
Ask a question