View: SO_SHIP_PRIORITIES_ACTIVE_V

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

View Text

SELECT MEANING SHIPMENT_PRIORITY
, LOOKUP_CODE SHIPMENT_PRIORITY_CODE
FROM SO_LOOKUPS
WHERE LOOKUP_TYPE = 'SHIPMENT_PRIORITY'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns