View: AP_HOLD_CODES_HOLD_NAME_V

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

View Text

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

Columns