VIEW: APPS.GMS_PROJECT_FUNDINGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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