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.SO_ENTRY_STATUSES_ACTIVE_V

Source

View Text - Preformatted


SELECT SR.NAME ENTRY_STATUS , SR.RESULT_ID FROM SO_RESULTS SR, SO_ACTION_RESULTS SAR, SO_ACTIONS SA WHERE SA.ACTION_ID = 1 AND SYSDATE BETWEEN NVL(SA.START_DATE_ACTIVE,SYSDATE) AND NVL(SA.END_DATE_ACTIVE,SYSDATE) AND SAR.ACTION_ID = SA.ACTION_ID AND SYSDATE BETWEEN NVL(SAR.START_DATE_ACTIVE,SYSDATE) AND NVL(SAR.END_DATE_ACTIVE,SYSDATE) AND SR.RESULT_ID = SAR.RESULT_ID AND SYSDATE BETWEEN NVL(SR.START_DATE_ACTIVE,SYSDATE) AND NVL(SR.END_DATE_ACTIVE,SYSDATE)

View Text - HTML Formatted

SELECT SR.NAME ENTRY_STATUS
, SR.RESULT_ID
FROM SO_RESULTS SR
, SO_ACTION_RESULTS SAR
, SO_ACTIONS SA
WHERE SA.ACTION_ID = 1
AND SYSDATE BETWEEN NVL(SA.START_DATE_ACTIVE
, SYSDATE)
AND NVL(SA.END_DATE_ACTIVE
, SYSDATE)
AND SAR.ACTION_ID = SA.ACTION_ID
AND SYSDATE BETWEEN NVL(SAR.START_DATE_ACTIVE
, SYSDATE)
AND NVL(SAR.END_DATE_ACTIVE
, SYSDATE)
AND SR.RESULT_ID = SAR.RESULT_ID
AND SYSDATE BETWEEN NVL(SR.START_DATE_ACTIVE
, SYSDATE)
AND NVL(SR.END_DATE_ACTIVE
, SYSDATE)