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
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
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV
Blitz Report™