ECC Property Manager, Projection Data Set

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: pn-projection
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 * FROM
(SELECT
ACCOUNTING_METHOD,
AMOUNT,
ECC_SPEC_ID,
LANGUAGE,
LEASE_ID,
LEASE_TYPE,
ORG_ID,
PAYMENT_TERM_ID,
PROJ_DATE,
TO_CHAR(PROJ_DATE,'YYYY-MM') REP_PERIOD,
REGIME_CODE,
STREAM_TYPE_CODE,
YEAR,
PROCESSING_STATUS_FLAG
FROM
PN_ECC_PROJECTION_V where language in ('US')
) PIVOT (MAX(ACCOUNTING_METHOD) AS ACCOUNTING_METHOD,
         MAX(STREAM_TYPE_CODE) AS STREAM_TYPE_CODE
FOR LANGUAGE in  ('US' "US"))
) 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 Generate Lease Details ECC Property Manager, Normalized Data for Property Manager Leases ECC Property Manager, Lease Expenses PN Generate Portfolio Summary ECC Enterprise Asset Management, Assets (Maintenance) PN Generate Lease Analysis PN Generate Portfolio Detail ECC Enterprise Asset Management, Work Order Assets (Maintenance)
Blitz Report™

Blitz Report™ provides multiple benefits: