Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PA_EGO_LC_PHASES_V |
SELECT STS.PROJECT_STATUS_CODE
, STS.PROJECT_STATUS_NAME
, STS.PROJECT_SYSTEM_STATUS_CODE
, STS.START_DATE_ACTIVE
, STS.END_DATE_ACTIVE
, STS.DESCRIPTION
, STS.PREDEFINED_FLAG
, STS.STARTING_STATUS_FLAG
, STS.LAST_UPDATE_DATE
, STS.LAST_UPDATED_BY
, STS.CREATION_DATE
, STS.CREATED_BY
, STS.LAST_UPDATE_LOGIN
, STS.NEXT_ALLOWABLE_STATUS_FLAG
, STS.ENABLE_WF_FLAG
, STS.WORKFLOW_ITEM_TYPE
, STS.WORKFLOW_PROCESS
, STS.WF_SUCCESS_STATUS_CODE
, STS.WF_FAILURE_STATUS_CODE
, STS.STATUS_ICON_IND
, STS.STATUS_ICON_ACTIVE_IND
, STS.PROJECT_STATUS_WEIGHT FROM PA_PROJECT_STATUSES STS
WHERE STS.STATUS_TYPE = 'PHASE' AND SYSDATE BETWEEN NVL(STS.START_DATE_ACTIVE
, SYSDATE)
AND NVL(STS.END_DATE_ACTIVE
, SYSDATE+1)