View: PA_SUMMARY_PROJECT_RETNS_V

Product:	PA - Projects
Description:	Stores retention summary amounts
Implementation/DBA Data:	APPS.PA_SUMMARY_PROJECT_RETNS_V

View Text

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'

Columns