VIEW: APPS.PA_PROJ_RETN_EVENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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