VIEW: APPS.AP_HOLDS_RELEASE_NAME_V

Source

View Text - Preformatted

SELECT C.HOLD_LOOKUP_CODE RELEASE_LOOKUP_CODE , L.DISPLAYED_FIELD RELEASE , L.DESCRIPTION REASON , C.HOLD_TYPE HOLD_TYPE FROM AP_HOLD_CODES C, AP_LOOKUP_CODES L WHERE C.HOLD_TYPE LIKE '%RELEASE%' AND L.LOOKUP_TYPE = 'HOLD CODE' AND NVL(C.INACTIVE_DATE,SYSDATE + 1) > SYSDATE AND L.LOOKUP_CODE = C.HOLD_LOOKUP_CODE

View Text - HTML Formatted

SELECT C.HOLD_LOOKUP_CODE RELEASE_LOOKUP_CODE
, L.DISPLAYED_FIELD RELEASE
, L.DESCRIPTION REASON
, C.HOLD_TYPE HOLD_TYPE
FROM AP_HOLD_CODES C
, AP_LOOKUP_CODES L
WHERE C.HOLD_TYPE LIKE '%RELEASE%'
AND L.LOOKUP_TYPE = 'HOLD CODE'
AND NVL(C.INACTIVE_DATE
, SYSDATE + 1) > SYSDATE
AND L.LOOKUP_CODE = C.HOLD_LOOKUP_CODE