View: SO_ENTRY_STATUSES_ACTIVE_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_ENTRY_STATUSES_ACTIVE_V

View Text

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)

Columns