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
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 |