VIEW: APPS.GMS_IP_AWARD_LOV_V

Source

View Text - Preformatted

SELECT DISTINCT AW.AWARD_ID AWARD_ID , SU.PROJECT_ID PROJECT_ID , AW.AWARD_NUMBER AWARD_NUMBER , AW.AWARD_SHORT_NAME AWARD_SHORT_NAME , nvl(AW.PREAWARD_DATE, AW.START_DATE_ACTIVE) START_DATE_ACTIVE , AW.END_DATE_ACTIVE , AW.ORG_ID FROM GMS_AWARDS_ALL AW , GMS_INSTALLMENTS INS , GMS_SUMMARY_PROJECT_FUNDINGS SU , PA_TASKS T WHERE 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 AW.STATUS <> 'CLOSED' AND AW.AWARD_TEMPLATE_FLAG = 'DEFERRED' UNION SELECT DEFAULT_DIST_AWARD_ID AWARD_ID , TO_NUMBER(NULL) PROJECT_ID , DEFAULT_DIST_AWARD_NUMBER AWARD_NUMBER , DEFAULT_DIST_AWARD_NUMBER AWARD_SHORT_NAME , SYSDATE START_DATE_ACTIVE , TO_DATE(NULL) END_DATE_ACTIVE , ORG_ID FROM GMS_IMPLEMENTATIONS WHERE award_distribution_option = 'Y'

View Text - HTML Formatted

SELECT DISTINCT AW.AWARD_ID AWARD_ID
, SU.PROJECT_ID PROJECT_ID
, AW.AWARD_NUMBER AWARD_NUMBER
, AW.AWARD_SHORT_NAME AWARD_SHORT_NAME
, NVL(AW.PREAWARD_DATE
, AW.START_DATE_ACTIVE) START_DATE_ACTIVE
, AW.END_DATE_ACTIVE
, AW.ORG_ID
FROM GMS_AWARDS_ALL AW
, GMS_INSTALLMENTS INS
, GMS_SUMMARY_PROJECT_FUNDINGS SU
, PA_TASKS T
WHERE 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 AW.STATUS <> 'CLOSED'
AND AW.AWARD_TEMPLATE_FLAG = 'DEFERRED' UNION SELECT DEFAULT_DIST_AWARD_ID AWARD_ID
, TO_NUMBER(NULL) PROJECT_ID
, DEFAULT_DIST_AWARD_NUMBER AWARD_NUMBER
, DEFAULT_DIST_AWARD_NUMBER AWARD_SHORT_NAME
, SYSDATE START_DATE_ACTIVE
, TO_DATE(NULL) END_DATE_ACTIVE
, ORG_ID
FROM GMS_IMPLEMENTATIONS
WHERE AWARD_DISTRIBUTION_OPTION = 'Y'