OKL Pre Billing
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source: Pre Billing Report
Short Name: OKLPREBILL
DB package: OKL_REPORT_PVT
Source: Pre Billing Report
Short Name: OKLPREBILL
DB package: OKL_REPORT_PVT
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() |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| To Bill Date | Date | ||
| Contract Number | LOV Oracle | ||
| Customer Account | LOV Oracle |