VIEW: APPS.AP_HOLDS_HOLD_NAME_V

Source

View Text - Preformatted

SELECT C.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE , L.DISPLAYED_FIELD HOLD , L.DESCRIPTION REASON , C.HOLD_TYPE LOOKUP_TYPE , C.USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG FROM AP_HOLD_CODES C, AP_LOOKUP_CODES L WHERE C.HOLD_TYPE in ( 'INVOICE HOLD REASON' , 'VARIANCE HOLD REASON', 'MATCHING HOLD REASON', 'INSUFFICIENT FUNDS') 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 HOLD_LOOKUP_CODE
, L.DISPLAYED_FIELD HOLD
, L.DESCRIPTION REASON
, C.HOLD_TYPE LOOKUP_TYPE
, C.USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG
FROM AP_HOLD_CODES C
, AP_LOOKUP_CODES L
WHERE C.HOLD_TYPE IN ( 'INVOICE HOLD REASON'
, 'VARIANCE HOLD REASON'
, 'MATCHING HOLD REASON'
, 'INSUFFICIENT FUNDS')
AND L.LOOKUP_TYPE = 'HOLD CODE'
AND NVL(C.INACTIVE_DATE
, SYSDATE + 1) > SYSDATE
AND L.LOOKUP_CODE = C.HOLD_LOOKUP_CODE