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
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,
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
Blitz Report™