ECC Projects, Projects Billing: Funding
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Projects Billing Summary Funding Details
Dataset Key: pa-ds-bill-funding
Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA
Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues
Description: Projects Billing Summary Funding Details
Dataset Key: pa-ds-bill-funding
Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_FUNDING_DATA
Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues
Run
ECC Projects, Projects Billing: Funding and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( select * from ( SELECT RECORD_TYPE, ECC_SPEC_ID, PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, ORG_ID, OPERATING_UNIT, PROJECT_START_DATE, PROJECT_COMPLETION_DATE, PROJECT_TYPE, PROJECT_TYPE_CLASS_CODE, PROJECT_STATUS_CODE, PROJECT_SYSTEM_STATUS_CODE, PROJFUNC_CURRENCY_CODE, REVENUE_ACCRUAL_METHOD, INVOICE_METHOD, ENABLE_TOP_TASK_INV_MTH_FLAG, BILLING_CYCLE_ID, BILLING_CYCLE_NAME, BILLING_OFFSET, NEXT_INVOICE_DATE, FUNDING_TASK_ID, FUNDING_TASK_NUMBER, FUNDING_TASK_NAME, TASK_START_DATE, TASK_COMPLETION_DATE, AGREEMENT_ID, AGREEMENT_NUM, CUSTOMER_ID, PARTY_NUMBER, PARTY_NAME, AGREEMENT_ORGANIZATION_ID, AGREEMENT_CURRENCY_CODE, AGREEMENT_START_DATE, AGREEMENT_EXPIRATION_DATE, REVENUE_LIMIT_FLAG, INVOICE_LIMIT_FLAG, REVENUE_HARD_LIMIT, INVOICE_HARD_LIMIT, TERM_ID, TERM_NAME, AGREEMENT_DESCRIPTION, BILLING_SEQUENCE, FUNDING_CURRENCY_CODE, TOTAL_UNBASELINED_AMOUNT, TOTAL_BASELINED_AMOUNT, TOTAL_ALLOCATED, TOTAL_REVENUE, INVOICED_AMOUNT, REVENUE_WRITEOFF, RETENTION_WITHHELD, RETENTION_BILLED, PROJECT_CURRENCY_CODE, PROJECT_UNBASELINED_AMOUNT, PROJECT_BASELINED_AMOUNT, PROJECT_ALLOCATED, PROJECT_REVENUE, PROJECT_INVOICED_AMOUNT, PROJECT_REVENUE_WRITEOFF, PROJECT_RETENTION_WITHHELD, PROJECT_RETENTION_BILLED, SPF_PROJFUNC_CURRENCY_CODE, PROJFUNC_UNBASELINED_AMOUNT, PROJFUNC_BASELINED_AMOUNT, PROJFUNC_ALLOCATED, PROJFUNC_REVENUE, PROJFUNC_INVOICED_AMOUNT, PROJFUNC_REVENUE_WRITEOFF, PROJFUNC_RETENTION_WITHHELD, PROJFUNC_RETENTION_BILLED, BUDGET_VERSION_ID, PROJECT_ITD_BUDGET, PROJECT_ITD_REVENUE, concession_amount, project_concession_amount, projfunc_concession_amount, PROJECT_ID||':'||FUNDING_TASK_ID DS_ASSOC_PRJ_TSK_ATTR, LANGUAGE FROM PA_ECC_BILL_FUNDING where language in ('US'))PIVOT ( max(OPERATING_UNIT) as OPERATING_UNIT, max(REVENUE_HARD_LIMIT) as REVENUE_HARD_LIMIT, max(INVOICE_HARD_LIMIT) as INVOICE_HARD_LIMIT, max(TERM_NAME) as TERM_NAME for LANGUAGE in ('US' "US")) ) x where 2=2 |