View: AP_HOLDS_HOLD_NAME_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AP_HOLDS_HOLD_NAME_V

View Text

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

Columns