[Home] [Help]
View: GMS_IP_AWARD_LOV_V
View Text
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'
Columns
Name |
AWARD_ID |
PROJECT_ID |
AWARD_NUMBER |
AWARD_SHORT_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ORG_ID |