VIEW: APPS.GMS_SSA_AWARDS_V

Source

View Text - Preformatted

SELECT DISTINCT AW.AWARD_ID AWARD_ID , AW.AWARD_NUMBER AWARD_NUMBER , AW.AWARD_SHORT_NAME AWARD_SHORT_NAME , AWARD_ORGANIZATION_ID , HR.NAME AWARD_ORGANIZATION_NAME , NVL(AW.PREAWARD_DATE, AW.START_DATE_ACTIVE) START_DATE , AW.END_DATE_ACTIVE END_DATE , AW.CLOSE_DATE CLOSE_DATE , SU.PROJECT_ID PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , T.TASK_ID TASK_ID , T.TASK_NUMBER TASK_NUMBER , AW.ORG_ID FROM GMS_AWARDS AW , GMS_INSTALLMENTS INS , GMS_SUMMARY_PROJECT_FUNDINGS SU , PA_PROJECTS_ALL P , PA_TASKS T , HR_ORGANIZATION_UNITS HR WHERE P.PROJECT_ID = SU.PROJECT_ID AND SU.PROJECT_ID = T.PROJECT_ID AND ((SU.TASK_ID= T.TASK_ID) OR (SU.TASK_ID IS NULL) OR (SU.TASK_ID = T.TOP_TASK_ID )) AND SU.INSTALLMENT_ID=INS.INSTALLMENT_ID AND INS.AWARD_ID=AW.AWARD_ID AND EXISTS (SELECT BUDGET_VERSION_ID FROM GMS_BUDGET_VERSIONS WHERE AWARD_ID = AW.AWARD_ID AND PROJECT_ID = SU.PROJECT_ID AND BUDGET_STATUS_CODE = 'B' ) AND AW.STATUS IN ('AT_RISK', 'ACTIVE') AND AW.AWARD_TEMPLATE_FLAG = 'DEFERRED' AND T.CHARGEABLE_FLAG = 'Y' AND AW.AWARD_ORGANIZATION_ID = HR.ORGANIZATION_ID

View Text - HTML Formatted

SELECT DISTINCT AW.AWARD_ID AWARD_ID
, AW.AWARD_NUMBER AWARD_NUMBER
, AW.AWARD_SHORT_NAME AWARD_SHORT_NAME
, AWARD_ORGANIZATION_ID
, HR.NAME AWARD_ORGANIZATION_NAME
, NVL(AW.PREAWARD_DATE
, AW.START_DATE_ACTIVE) START_DATE
, AW.END_DATE_ACTIVE END_DATE
, AW.CLOSE_DATE CLOSE_DATE
, SU.PROJECT_ID PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, T.TASK_ID TASK_ID
, T.TASK_NUMBER TASK_NUMBER
, AW.ORG_ID
FROM GMS_AWARDS AW
, GMS_INSTALLMENTS INS
, GMS_SUMMARY_PROJECT_FUNDINGS SU
, PA_PROJECTS_ALL P
, PA_TASKS T
, HR_ORGANIZATION_UNITS HR
WHERE P.PROJECT_ID = SU.PROJECT_ID
AND SU.PROJECT_ID = T.PROJECT_ID
AND ((SU.TASK_ID= T.TASK_ID) OR (SU.TASK_ID IS NULL) OR (SU.TASK_ID = T.TOP_TASK_ID ))
AND SU.INSTALLMENT_ID=INS.INSTALLMENT_ID
AND INS.AWARD_ID=AW.AWARD_ID
AND EXISTS (SELECT BUDGET_VERSION_ID
FROM GMS_BUDGET_VERSIONS
WHERE AWARD_ID = AW.AWARD_ID
AND PROJECT_ID = SU.PROJECT_ID
AND BUDGET_STATUS_CODE = 'B' )
AND AW.STATUS IN ('AT_RISK'
, 'ACTIVE')
AND AW.AWARD_TEMPLATE_FLAG = 'DEFERRED'
AND T.CHARGEABLE_FLAG = 'Y'
AND AW.AWARD_ORGANIZATION_ID = HR.ORGANIZATION_ID