OKL Accounting Period Sweep Process
Description
- Categories
- BI Publisher
- Application
- Lease and Finance Management
- Source
- Accounting Period Sweep Process
- Short Name
- OKLPDSWP
- DB package
- OKL_PERIOD_SWEEP_PVT
SQL 7 lines
SELECT OKL_ACCOUNTING_UTIL.get_message_token('OKL_LP_SWEEP_PROGRAM','OKL_SWEEP_PROGRAM_REPORT') REPORT_NAME, OKL_ACCOUNTING_UTIL.get_lookup_meaning('OKL_SWEEP_PGM_OPTION',:p_run_option) RUN_MODE, NAME OPERATING_UNIT, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') RUN_DATE FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID = MO_GLOBAL.get_current_org_id() |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Representation Code | LOV Oracle | |
| Transfer From Period | LOV Oracle | |
| Transfer To Period | LOV Oracle | |
| Mode | LOV Oracle |