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
Source: UK Reverse Charge Sales List Report
Short Name: JEUKRSLR_XMLP
DB package: JE_REVERSE_SALES_LIST_PKG
Run
JE UK Reverse Charge Sales List and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Legal Entity |
|
LOV Oracle | |
Tax Registration Number |
|
LOV Oracle | |
From Date |
|
Date | |
To Date |
|
Date |