ECC Property Manager, Normalized Data for Property Manager Leases

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Download
 
Related Blitz Reports
ECC Property Manager, Lease Pay Terms Data Set PN Billing/Payment Upload ECC Property Manager, Lease Expenses PN Generate Lease Details ECC Property Manager, Projection Data Set PN Generate Portfolio Summary PN Generate Lease Analysis PN Generate Portfolio Detail ECC Enterprise Asset Management, Work Order Assets (Maintenance)
Blitz Report™

Blitz Report™ provides multiple benefits: