VIEW: APPS.PO_DESTINATION_TYPES_VAL_V

Source

View Text - Preformatted

SELECT DISPLAYED_FIELD , DESCRIPTION , LOOKUP_CODE FROM PO_LOOKUP_CODES WHERE LOOKUP_TYPE = 'DESTINATION TYPE' AND SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1)

View Text - HTML Formatted

SELECT DISPLAYED_FIELD
, DESCRIPTION
, LOOKUP_CODE
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'DESTINATION TYPE'
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)