eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_EGO_LC_PHASES_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)