ECC Projects, Projects Billing: Funding

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

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