ECC Property Manager, Lease Expenses

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: pn-expenses
Query Procedure: pn_ecc_load_pkg.GET_ECC_DATA_LOAD_INFO
Security Procedure: pn_ecc_load_pkg.GetFilterAttributeValues
select
x.*
from
(
SELECT * FROM
(
SELECT
ACCOUNTING_METHOD,
AMOUNT,
ECC_SPEC_ID,
pn_ecc_util_pvt.get_lookup_values('PN_YES_NO', EXEMPT_YN, language) EXEMPT_YN,
EXPENSE_PURPOSE,
ITEM_CATEGORY,
LANGUAGE,
LEASE_CLASS,
LEASE_ID,
LEASE_NUM,
LIFE_MONTHS,
ORG_ID,
PAYMENT_TERM_ID,
PERIOD_START_DATE,
PRIMARY_REGIME,
REGIME_CODE,
STREAM_DATE,
STREAM_TYPE_CODE,
TRANSACTED_FLAG,
to_char(stream_date,'YYYY-MM') rep_period,
to_char(stream_date,'YYYY-MM') month,
PROCESSING_STATUS_FLAG
from  PN_ECC_LEASE_EXPENSE_V where language in ('US')
) PIVOT (MAX(ACCOUNTING_METHOD) AS ACCOUNTING_METHOD,
         MAX(EXEMPT_YN) AS EXEMPT_YN,
         MAX(EXPENSE_PURPOSE) AS EXPENSE_PURPOSE,
         MAX(LEASE_CLASS) AS LEASE_CLASS
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