ECC Property Manager, Projection Data Set

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
Run ECC Property Manager, Projection Data Set and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™