View: PA_PROJ_RETN_EVENTS_V

Product:	PA - Projects
Description:	Stores retention events rules
Implementation/DBA Data:	APPS.PA_PROJ_RETN_EVENTS_V

View Text

SELECT RT.ROWID ROW_ID
, RT.RETENTION_RULE_ID
, RL.RETENTION_LEVEL_CODE
, RT.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))
, RT.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))
, RT.AGREEMENT_ID
, A.AGREEMENT_NUM
, A.CUSTOMER_ID
, CUST_ACCT.ACCOUNT_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, RL.EFFECTIVE_START_DATE
, RL.EFFECTIVE_END_DATE
, RL.RETENTION_PERCENTAGE
, RL.RETENTION_AMOUNT
, RL.THRESHOLD_AMOUNT
, RL.REVENUE_CATEGORY_CODE
, LK1.MEANING REVENUE_CATEGORY_DESC
, RL.EVENT_TYPE
, RT.INVPROC_CURRENCY_CODE
, RT.TOTAL_RETAINED
, RT.FUNDING_CURRENCY_CODE
, RT.FUNDING_TOTAL_RETAINED
, RT.PROJECT_CURRENCY_CODE
, RT.PROJECT_TOTAL_RETAINED
, RT.PROJFUNC_CURRENCY_CODE
, RT.PROJFUNC_TOTAL_RETAINED
FROM PA_LOOKUPS LK
, PA_TASKS T
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, PA_AGREEMENTS_ALL A
, PA_PROJECTS_ALL P
, PA_PROJECT_RETENTIONS RT
, PA_PROJ_RETN_RULES RL
, PA_LOOKUPS LK1
WHERE T.PROJECT_ID(+) = RT.PROJECT_ID
AND T.TASK_ID(+) = RT.TASK_ID
AND RT.RETENTION_RULE_ID = RL.RETENTION_RULE_ID
AND RL.RETENTION_LEVEL_CODE IN ('EVENT_TYPE'
, 'REVENUE_CATEGORY')
AND P.PROJECT_ID = DECODE(CUST_ACCT.CUST_ACCOUNT_ID
, NULL
, NULL
, RT.PROJECT_ID)
AND CUST_ACCT.PARTY_ID=PARTY.PARTY_ID
AND A.AGREEMENT_ID = RT.AGREEMENT_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = A.CUSTOMER_ID
AND LK.LOOKUP_TYPE = DECODE(P.PROJECT_ID
, NULL
, NULL
, 'TRANSLATION')
AND LK.LOOKUP_CODE ||'' = 'SECURED_DATA'
AND LK1.LOOKUP_TYPE = 'REVENUE CATEGORY'
AND LK1.LOOKUP_CODE = RL.REVENUE_CATEGORY_CODE

Columns