VIEW: APPS.PA_SUMMARY_PROJECT_RETNS_V

Source

View Text - Preformatted

SELECT F.ROWID ROW_ID , 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 , LK1.MEANING RETENTION_LEVEL_NAME , CUST_ACCT.ACCOUNT_NUMBER , SUBSTRB(PARTY.PARTY_NAME,1,50) , F.INVPROC_CURRENCY_CODE , F.TOTAL_RETAINED , F.TOTAL_BILLED , F.TOTAL_WRITEOFF , F.FUNDING_CURRENCY_CODE , F.FUNDING_TOTAL_RETAINED , F.FUNDING_TOTAL_BILLED , F.FUNDING_TOTAL_WRITEOFF , F.PROJECT_CURRENCY_CODE , F.PROJECT_TOTAL_RETAINED , F.PROJECT_TOTAL_BILLED , F.PROJECT_TOTAL_WRITEOFF , F.PROJFUNC_CURRENCY_CODE , F.PROJFUNC_TOTAL_RETAINED , F.PROJFUNC_TOTAL_BILLED , F.PROJFUNC_TOTAL_WRITEOFF FROM PA_LOOKUPS LK, PA_LOOKUPS LK1, PA_TASKS T, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, PA_AGREEMENTS_ALL A, PA_PROJECTS_ALL P, PA_SUMMARY_PROJECT_RETN F, PA_PROJECT_CUSTOMERS PC WHERE T.PROJECT_ID(+) = F.PROJECT_ID AND T.TASK_ID(+) = F.TASK_ID AND P.PROJECT_ID = DECODE(CUST_ACCT.CUST_ACCOUNT_ID, NULL, NULL, F.PROJECT_ID) AND CUST_ACCT.PARTY_ID=PARTY.PARTY_ID AND A.AGREEMENT_ID = F.AGREEMENT_ID AND CUST_ACCT.CUST_ACCOUNT_ID = A.CUSTOMER_ID AND PC.CUSTOMER_ID = F.CUSTOMER_ID AND PC.PROJECT_ID = F.PROJECT_ID AND LK1.LOOKUP_TYPE(+) = 'RETENTION_LEVEL' AND LK1.LOOKUP_CODE(+) = DECODE (PC.RETENTION_LEVEL_CODE, NULL, 'NO_RETENTION', PC.RETENTION_LEVEL_CODE) AND LK.LOOKUP_TYPE = DECODE(P.PROJECT_ID, NULL, NULL, 'TRANSLATION') AND LK.LOOKUP_CODE ||'' = 'SECURED_DATA'

View Text - HTML Formatted

SELECT F.ROWID ROW_ID
, 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
, LK1.MEANING RETENTION_LEVEL_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, F.INVPROC_CURRENCY_CODE
, F.TOTAL_RETAINED
, F.TOTAL_BILLED
, F.TOTAL_WRITEOFF
, F.FUNDING_CURRENCY_CODE
, F.FUNDING_TOTAL_RETAINED
, F.FUNDING_TOTAL_BILLED
, F.FUNDING_TOTAL_WRITEOFF
, F.PROJECT_CURRENCY_CODE
, F.PROJECT_TOTAL_RETAINED
, F.PROJECT_TOTAL_BILLED
, F.PROJECT_TOTAL_WRITEOFF
, F.PROJFUNC_CURRENCY_CODE
, F.PROJFUNC_TOTAL_RETAINED
, F.PROJFUNC_TOTAL_BILLED
, F.PROJFUNC_TOTAL_WRITEOFF
FROM PA_LOOKUPS LK
, PA_LOOKUPS LK1
, PA_TASKS T
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, PA_AGREEMENTS_ALL A
, PA_PROJECTS_ALL P
, PA_SUMMARY_PROJECT_RETN F
, PA_PROJECT_CUSTOMERS PC
WHERE T.PROJECT_ID(+) = F.PROJECT_ID
AND T.TASK_ID(+) = F.TASK_ID
AND P.PROJECT_ID = DECODE(CUST_ACCT.CUST_ACCOUNT_ID
, NULL
, NULL
, F.PROJECT_ID)
AND CUST_ACCT.PARTY_ID=PARTY.PARTY_ID
AND A.AGREEMENT_ID = F.AGREEMENT_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = A.CUSTOMER_ID
AND PC.CUSTOMER_ID = F.CUSTOMER_ID
AND PC.PROJECT_ID = F.PROJECT_ID
AND LK1.LOOKUP_TYPE(+) = 'RETENTION_LEVEL'
AND LK1.LOOKUP_CODE(+) = DECODE (PC.RETENTION_LEVEL_CODE
, NULL
, 'NO_RETENTION'
, PC.RETENTION_LEVEL_CODE)
AND LK.LOOKUP_TYPE = DECODE(P.PROJECT_ID
, NULL
, NULL
, 'TRANSLATION')
AND LK.LOOKUP_CODE ||'' = 'SECURED_DATA'