VIEW: APPS.PA_SUM_PROJECT_FUNDINGS2_V

Source

View Text - Preformatted

SELECT MC.ROWID ROW_ID , MC.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)) , MC.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)) , MC.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 , MC.CURRENCY_CODE , MC.TOTAL_UNBASELINED_AMOUNT , MC.TOTAL_BASELINED_AMOUNT , MC.TOTAL_UNBASELINED_AMOUNT + nvl(MC.TOTAL_BASELINED_AMOUNT,0) PROJFUNC_ALLOCATED , MC.TOTAL_ACCRUED_AMOUNT , MC.TOTAL_ACCRUED_AMOUNT PROJFUNC_REVENUE , MC.TOTAL_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 OWNING_ORGANIZATION_ID ,F.GLOBAL_ATTRIBUTE_CATEGORY ,F.GLOBAL_ATTRIBUTE1 ,F.GLOBAL_ATTRIBUTE2 ,F.GLOBAL_ATTRIBUTE3 ,F.GLOBAL_ATTRIBUTE4 ,F.GLOBAL_ATTRIBUTE5 ,F.GLOBAL_ATTRIBUTE6 ,F.GLOBAL_ATTRIBUTE7 ,F.GLOBAL_ATTRIBUTE8 ,F.GLOBAL_ATTRIBUTE9 ,F.GLOBAL_ATTRIBUTE10 ,F.GLOBAL_ATTRIBUTE11 ,F.GLOBAL_ATTRIBUTE12 ,F.GLOBAL_ATTRIBUTE13 ,F.GLOBAL_ATTRIBUTE14 ,F.GLOBAL_ATTRIBUTE15 ,F.GLOBAL_ATTRIBUTE16 ,F.GLOBAL_ATTRIBUTE17 ,F.GLOBAL_ATTRIBUTE18 ,F.GLOBAL_ATTRIBUTE19 ,F.GLOBAL_ATTRIBUTE20 ,F.GLOBAL_ATTRIBUTE21 ,F.GLOBAL_ATTRIBUTE22 ,F.GLOBAL_ATTRIBUTE23 ,F.GLOBAL_ATTRIBUTE24 ,F.GLOBAL_ATTRIBUTE25 ,F.GLOBAL_ATTRIBUTE26 ,F.GLOBAL_ATTRIBUTE27 ,F.GLOBAL_ATTRIBUTE28 ,F.GLOBAL_ATTRIBUTE29 ,F.GLOBAL_ATTRIBUTE30 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)

View Text - HTML Formatted

SELECT MC.ROWID ROW_ID
, MC.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))
, MC.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))
, MC.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
, MC.CURRENCY_CODE
, MC.TOTAL_UNBASELINED_AMOUNT
, MC.TOTAL_BASELINED_AMOUNT
, MC.TOTAL_UNBASELINED_AMOUNT + NVL(MC.TOTAL_BASELINED_AMOUNT
, 0) PROJFUNC_ALLOCATED
, MC.TOTAL_ACCRUED_AMOUNT
, MC.TOTAL_ACCRUED_AMOUNT PROJFUNC_REVENUE
, MC.TOTAL_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 OWNING_ORGANIZATION_ID
, F.GLOBAL_ATTRIBUTE_CATEGORY
, F.GLOBAL_ATTRIBUTE1
, F.GLOBAL_ATTRIBUTE2
, F.GLOBAL_ATTRIBUTE3
, F.GLOBAL_ATTRIBUTE4
, F.GLOBAL_ATTRIBUTE5
, F.GLOBAL_ATTRIBUTE6
, F.GLOBAL_ATTRIBUTE7
, F.GLOBAL_ATTRIBUTE8
, F.GLOBAL_ATTRIBUTE9
, F.GLOBAL_ATTRIBUTE10
, F.GLOBAL_ATTRIBUTE11
, F.GLOBAL_ATTRIBUTE12
, F.GLOBAL_ATTRIBUTE13
, F.GLOBAL_ATTRIBUTE14
, F.GLOBAL_ATTRIBUTE15
, F.GLOBAL_ATTRIBUTE16
, F.GLOBAL_ATTRIBUTE17
, F.GLOBAL_ATTRIBUTE18
, F.GLOBAL_ATTRIBUTE19
, F.GLOBAL_ATTRIBUTE20
, F.GLOBAL_ATTRIBUTE21
, F.GLOBAL_ATTRIBUTE22
, F.GLOBAL_ATTRIBUTE23
, F.GLOBAL_ATTRIBUTE24
, F.GLOBAL_ATTRIBUTE25
, F.GLOBAL_ATTRIBUTE26
, F.GLOBAL_ATTRIBUTE27
, F.GLOBAL_ATTRIBUTE28
, F.GLOBAL_ATTRIBUTE29
, F.GLOBAL_ATTRIBUTE30
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)