View: AP_LC_QUICK_RELEASES_V

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

View Text

SELECT HC.HOLD_LOOKUP_CODE RELEASE_LOOKUP_CODE
, LC.DISPLAYED_FIELD RELEASE
, HC.DESCRIPTION RELEASE_REASON
FROM AP_HOLD_CODES HC
, AP_LOOKUP_CODES LC
WHERE HC.HOLD_TYPE = 'HOLD QUICK RELEASE REASON'
AND SYSDATE <= NVL(LC.INACTIVE_DATE
, SYSDATE)
AND HC.HOLD_LOOKUP_CODE = LC.LOOKUP_CODE
AND LC.LOOKUP_TYPE = 'HOLD CODE'

Columns