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
Dataset Key: pn-expenses
Query Procedure: pn_ecc_load_pkg.GET_ECC_DATA_LOAD_INFO
Security Procedure: pn_ecc_load_pkg.GetFilterAttributeValues
Run
ECC Property Manager, Lease Expenses and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
|
LOV |