Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_PROJECT_FUNDINGS_V |
SELECT F.ROWID ROW_ID
, F.GMS_PROJECT_FUNDING_ID
, F.PROJECT_FUNDING_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.INSTALLMENT_ID
, F.FUNDING_AMOUNT
, F.DATE_ALLOCATED
, NULL CREATED_BY_PERSON_NAME
, PT.ALLOWABLE_FUNDING_LEVEL_CODE
, PT.PROJECT_TYPE_CLASS_CODE
, F.LAST_UPDATE_DATE
, F.LAST_UPDATED_BY
, F.CREATION_DATE
, F.CREATED_BY
, F.LAST_UPDATE_LOGIN
, I.INSTALLMENT_NUM
, I.AWARD_ID
, PT.ORG_ID
FROM PA_LOOKUPS LK
, PA_PROJECT_TYPES PT
, PA_TASKS T
, PA_PROJECTS_ALL P
, GMS_PROJECT_FUNDINGS F
, GMS_INSTALLMENTS I
WHERE P.PROJECT_ID = F.PROJECT_ID
AND T.TASK_ID (+) = F.TASK_ID
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND LK.LOOKUP_TYPE = 'TRANSLATION'
AND LK.LOOKUP_CODE = 'SECURED_DATA'
AND I.INSTALLMENT_ID = F.INSTALLMENT_ID
AND PT.ORG_ID = P.ORG_ID