VIEW: APPS.PO_INSPECTION_RESULTS_VAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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