ECC Property Manager, Normalized Data for Property Manager Leases
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: pn-normalize
Query Procedure: pn_ecc_load_pkg.GET_ECC_DATA_LOAD_INFO
Security Procedure: pn_ecc_load_pkg.GetFilterAttributeValues
Dataset Key: pn-normalize
Query Procedure: pn_ecc_load_pkg.GET_ECC_DATA_LOAD_INFO
Security Procedure: pn_ecc_load_pkg.GetFilterAttributeValues
Run
ECC Property Manager, Normalized Data for Property Manager Leases and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( SELECT ACCOUNT_EXPENSE, ABS(ACCRUED_LIABILITY) ACCRUED_LIABILITY, ABS(ADJUSTMENT) ADJUSTMENT, CURRENCY_CODE, ECC_SPEC_ID, LEASE_ID, NORMALIZATION_CASH, SCHEDULE_DATE, TOTAL_CASH, TO_CHAR(SCHEDULE_DATE,'MON-YY') PERIOD, to_char(SCHEDULE_DATE,'YYYY-MM') rep_period, PROCESSING_STATUS_FLAG, ORG_ID FROM PN_ECC_NORMALIZE_V ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |