VIEW: APPS.GMS_SUM_PRJ_FUNDINGS_V

Source

View Text - Preformatted

SELECT F.ROWID ROW_ID, F.PROJECT_ID, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID), 'Y', P.SEGMENT1, LK.MEANING), DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID), 'Y', P.NAME, LK.MEANING) , F.TASK_ID , DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID), 'Y', T.TASK_NUMBER, LK.MEANING) , DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID), 'Y', T.TASK_NAME, LK.MEANING) , F.INSTALLMENT_ID, INS.INSTALLMENT_NUM , F.TOTAL_FUNDING_AMOUNT , F.TOTAL_REVENUE_AMOUNT , F.TOTAL_BILLED_AMOUNT , AWD.AGREEMENT_ID, AWD.AWARD_ID , AWD.AWARD_NUMBER , AWD.AWARD_SHORT_NAME , F.LAST_UPDATE_DATE , F.LAST_UPDATED_BY , F.CREATION_DATE , F.CREATED_BY , F.LAST_UPDATE_LOGIN, AWD.ORG_ID FROM PA_LOOKUPS LK, PA_TASKS T, PA_PROJECTS_ALL P, GMS_SUMMARY_PROJECT_FUNDINGS F, GMS_AWARDS AWD, GMS_INSTALLMENTS INS WHERE /* GMS_SECURITY.ALLOW_QUERY(AWD.AWARD_ID) = 'Y'*/ 'Y' in ( select GMS_SECURITY.ALLOW_QUERY(AWD.AWARD_ID) from sys.dual) AND T.PROJECT_ID(+) = F.PROJECT_ID AND T.TASK_ID(+) = F.TASK_ID AND P.PROJECT_ID = F.PROJECT_ID AND LK.LOOKUP_TYPE = 'TRANSLATION' AND LK.LOOKUP_CODE = 'SECURED_DATA' AND F.INSTALLMENT_ID = INS.INSTALLMENT_ID AND INS.AWARD_ID = AWD.AWARD_ID

View Text - HTML Formatted

SELECT F.ROWID ROW_ID
, F.PROJECT_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.SEGMENT1
, LK.MEANING)
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.NAME
, LK.MEANING)
, F.TASK_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NUMBER
, LK.MEANING)
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NAME
, LK.MEANING)
, F.INSTALLMENT_ID
, INS.INSTALLMENT_NUM
, F.TOTAL_FUNDING_AMOUNT
, F.TOTAL_REVENUE_AMOUNT
, F.TOTAL_BILLED_AMOUNT
, AWD.AGREEMENT_ID
, AWD.AWARD_ID
, AWD.AWARD_NUMBER
, AWD.AWARD_SHORT_NAME
, F.LAST_UPDATE_DATE
, F.LAST_UPDATED_BY
, F.CREATION_DATE
, F.CREATED_BY
, F.LAST_UPDATE_LOGIN
, AWD.ORG_ID
FROM PA_LOOKUPS LK
, PA_TASKS T
, PA_PROJECTS_ALL P
, GMS_SUMMARY_PROJECT_FUNDINGS F
, GMS_AWARDS AWD
, GMS_INSTALLMENTS INS
WHERE /* GMS_SECURITY.ALLOW_QUERY(AWD.AWARD_ID) = 'Y'*/ 'Y' IN ( SELECT GMS_SECURITY.ALLOW_QUERY(AWD.AWARD_ID)
FROM SYS.DUAL)
AND T.PROJECT_ID(+) = F.PROJECT_ID
AND T.TASK_ID(+) = F.TASK_ID
AND P.PROJECT_ID = F.PROJECT_ID
AND LK.LOOKUP_TYPE = 'TRANSLATION'
AND LK.LOOKUP_CODE = 'SECURED_DATA'
AND F.INSTALLMENT_ID = INS.INSTALLMENT_ID
AND INS.AWARD_ID = AWD.AWARD_ID