Product: | GMS - Grants Accounting |
---|---|
Description: | Commented the allow_query in where clause as per bug 1538406 |
Implementation/DBA Data: | APPS.GMS_SUM_PRJ_FUNDINGS_V |
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