View: PA_SUM_PROJ_FUND_FORMS_MRC_V

View Text

SELECT F.PROJECT_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.SEGMENT1
, SUBSTR(LK.MEANING
, 1
, 25))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.NAME
, SUBSTR(LK.MEANING
, 1
, 30))
, F.TASK_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NUMBER
, SUBSTR(LK.MEANING
, 1
, 25))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NAME
, SUBSTR(LK.MEANING
, 1
, 20))
, F.AGREEMENT_ID
, A.AGREEMENT_NUM
, A.CUSTOMER_ID
, HZ_P.PARTY_NUMBER
, HZ_P.PARTY_NAME
, F.TOTAL_UNBASELINED_AMOUNT
, F.TOTAL_BASELINED_AMOUNT
, F.TOTAL_UNBASELINED_AMOUNT + NVL(F.TOTAL_BASELINED_AMOUNT
, 0) TOTAL_ALLOCATED
, F.TOTAL_ACCRUED_AMOUNT
, 0 REVENUE_WRITEOFF
, F.TOTAL_ACCRUED_AMOUNT TOTAL_REVENUE
, F.TOTAL_BILLED_AMOUNT
, F.FUNDING_CURRENCY_CODE
, F.PROJECT_CURRENCY_CODE
, F.PROJECT_UNBASELINED_AMOUNT
, F.PROJECT_BASELINED_AMOUNT
, F.PROJECT_UNBASELINED_AMOUNT + NVL(F.PROJECT_BASELINED_AMOUNT
, 0) PROJECT_ALLOCATED
, F.PROJECT_ACCRUED_AMOUNT
, F.PROJECT_ACCRUED_AMOUNT PROJECT_REVENUE
, F.PROJECT_BILLED_AMOUNT
, F.PROJFUNC_CURRENCY_CODE
, F.PROJFUNC_UNBASELINED_AMOUNT
, F.PROJFUNC_BASELINED_AMOUNT
, F.PROJFUNC_UNBASELINED_AMOUNT + NVL(F.PROJFUNC_BASELINED_AMOUNT
, 0) PROJFUNC_ALLOCATED
, F.PROJFUNC_ACCRUED_AMOUNT
, F.PROJFUNC_ACCRUED_AMOUNT PROJFUNC_REVENUE
, F.PROJFUNC_BILLED_AMOUNT
, F.INVPROC_CURRENCY_CODE
, F.INVPROC_UNBASELINED_AMOUNT
, F.INVPROC_BASELINED_AMOUNT
, F.INVPROC_UNBASELINED_AMOUNT + NVL(F.INVPROC_BASELINED_AMOUNT
, 0) INVPROC_ALLOCATED
, F.INVPROC_BILLED_AMOUNT
, F.REVPROC_CURRENCY_CODE
, F.REVPROC_UNBASELINED_AMOUNT
, F.REVPROC_BASELINED_AMOUNT
, F.REVPROC_UNBASELINED_AMOUNT + NVL(F.REVPROC_BASELINED_AMOUNT
, 0) REVPROC_ALLOCATED
, F.REVPROC_ACCRUED_AMOUNT
, F.REVPROC_ACCRUED_AMOUNT REVPROC_REVENUE
, NULL NAME
, A.OWNING_ORGANIZATION_ID ORGANIZATION_ID
, MC.CURRENCY_CODE REP_PROJFUNC_CURRENCY_CODE
, MC.TOTAL_UNBASELINED_AMOUNT REP_PROJFUNC_UNBASELINED
, MC.TOTAL_BASELINED_AMOUNT REP_PROJFUNC_BASELINED
, (NVL(MC.TOTAL_UNBASELINED_AMOUNT
, 0)+NVL(MC.TOTAL_BASELINED_AMOUNT
, 0)) REP_PROJFUNC_ALLOCATED
, MC.TOTAL_ACCRUED_AMOUNT REP_PROJFUNC_ACCRUED_AMOUNT
, MC.TOTAL_ACCRUED_AMOUNT REP_PROJFUNC_REVENUE
, MC.TOTAL_BILLED_AMOUNT REP_PROJFUNC_BILLED
FROM PA_LOOKUPS LK
, PA_TASKS T
, HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS HZ_C
, PA_AGREEMENTS_ALL A
, PA_PROJECTS_ALL P
, PA_SUMMARY_PROJECT_FUNDINGS F
, PA_MC_SUM_PROJ_FUNDINGS MC
WHERE T.PROJECT_ID(+) = F.PROJECT_ID
AND T.TASK_ID(+) = F.TASK_ID
AND P.PROJECT_ID = DECODE(HZ_C.CUST_ACCOUNT_ID
, NULL
, NULL
, F.PROJECT_ID)
AND A.AGREEMENT_ID = F.AGREEMENT_ID
AND HZ_C.CUST_ACCOUNT_ID = A.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND LK.LOOKUP_TYPE = DECODE(P.PROJECT_ID
, NULL
, NULL
, 'TRANSLATION')
AND LK.LOOKUP_CODE ||'' = 'SECURED_DATA'
AND MC.PROJECT_ID = F.PROJECT_ID
AND MC.AGREEMENT_ID = F.AGREEMENT_ID
AND NVL(MC.TASK_ID
, -99) = NVL(F.TASK_ID
, -99)
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10))
, -99)

Columns