VIEW: APPS.GMS_AWARDS_BASIC_V

Source

View Text - Preformatted

SELECT DISTINCT AW.AWARD_ID AWARD_ID , AW.AWARD_NUMBER AWARD_NUMBER , AW.AWARD_SHORT_NAME AWARD_SHORT_NAME , SU.PROJECT_ID PROJECT_ID, T.TASK_ID TASK_ID , P.SEGMENT1 PROJECT_NUMBER, AW.ORG_ID FROM PA_PROJECTS_ALL P, PA_TASKS T , GMS_INSTALLMENTS INS, GMS_SUMMARY_PROJECT_FUNDINGS SU, GMS_BUDGET_VERSIONS BV, GMS_AWARDS AW WHERE BV.AWARD_ID =AW.AWARD_ID AND BV.BUDGET_STATUS_CODE||'' = 'B' AND SU.PROJECT_ID = BV.PROJECT_ID AND ((SU.TASK_ID= T.TASK_ID) OR (SU.TASK_ID IS NULL) OR (SU.TASK_ID = T.TOP_TASK_ID ) ) AND INS.INSTALLMENT_ID = SU.INSTALLMENT_ID AND INS.AWARD_ID = AW.AWARD_ID AND P.PROJECT_ID = BV.PROJECT_ID AND T.PROJECT_ID = BV.PROJECT_ID AND AW.STATUS <> 'CLOSED' AND AW.AWARD_TEMPLATE_FLAG = 'DEFERRED'

View Text - HTML Formatted

SELECT DISTINCT AW.AWARD_ID AWARD_ID
, AW.AWARD_NUMBER AWARD_NUMBER
, AW.AWARD_SHORT_NAME AWARD_SHORT_NAME
, SU.PROJECT_ID PROJECT_ID
, T.TASK_ID TASK_ID
, P.SEGMENT1 PROJECT_NUMBER
, AW.ORG_ID
FROM PA_PROJECTS_ALL P
, PA_TASKS T
, GMS_INSTALLMENTS INS
, GMS_SUMMARY_PROJECT_FUNDINGS SU
, GMS_BUDGET_VERSIONS BV
, GMS_AWARDS AW
WHERE BV.AWARD_ID =AW.AWARD_ID
AND BV.BUDGET_STATUS_CODE||'' = 'B'
AND SU.PROJECT_ID = BV.PROJECT_ID
AND ((SU.TASK_ID= T.TASK_ID) OR (SU.TASK_ID IS NULL) OR (SU.TASK_ID = T.TOP_TASK_ID ) )
AND INS.INSTALLMENT_ID = SU.INSTALLMENT_ID
AND INS.AWARD_ID = AW.AWARD_ID
AND P.PROJECT_ID = BV.PROJECT_ID
AND T.PROJECT_ID = BV.PROJECT_ID
AND AW.STATUS <> 'CLOSED'
AND AW.AWARD_TEMPLATE_FLAG = 'DEFERRED'