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
SQL 7 lines
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 |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Legal Entity | LOV Oracle | |
| Tax Registration Number | LOV Oracle | |
| From Date | Date | |
| To Date | Date |