ECC Projects, Projects Billing: Funding

Description
Categories: Enterprise Command Center
Columns: Record Type, Ecc Spec Id, Project Id, Project Name, Project Number, Org Id, Project Start Date, Project Completion Date, Project Type, Project Type Class Code ...
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
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,
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