OKL Pre Billing
Description
- Categories
- BI Publisher
- Application
- Lease and Finance Management
- Source
- Pre Billing Report
- Short Name
- OKLPREBILL
- DB package
- OKL_REPORT_PVT
SQL 8 lines
SELECT name OPERATING_UNIT, SYSDATE SYSTEM_DATE, :P_FROM_BILL_DATE FROM_DATE, :P_TO_BILL_DATE TO_DATE, FND_GLOBAL.CONC_REQUEST_ID REQUEST_ID FROM hr_operating_units WHERE organization_id = mo_global.get_current_org_id() |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| To Bill Date | Date | |
| Contract Number | LOV Oracle | |
| Customer Account | LOV Oracle |