View: AP_HOLD_CODES_V

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

View Text

SELECT AHC.ROWID ROW_ID
, AHC.CREATED_BY CREATED_BY
, AHC.CREATION_DATE CREATION_DATE
, AHC.DESCRIPTION DESCRIPTION
, L1.DISPLAYED_FIELD DISPLAYED_HOLD_CODE
, AHC.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE
, L2.DISPLAYED_FIELD DISPLAYED_HOLD_TYPE
, AHC.HOLD_TYPE HOLD_TYPE
, AHC.INACTIVE_DATE INACTIVE_DATE
, AHC.LAST_UPDATED_BY LAST_UPDATED_BY
, AHC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AHC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AHC.POSTABLE_FLAG POSTABLE_FLAG
, AHC.USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG
, AHC.USER_UPDATEABLE_FLAG USER_UPDATEABLE_FLAG
, AHC.HOLD_INSTRUCTION HOLD_INSTRUCTION
, AHC.WAIT_BEFORE_NOTIFY_DAYS WAIT_BEFORE_NOTIFY_DAYS
, AHC.REMINDER_DAYS REMAINDER_DAYS
, AHC.INITIATE_WORKFLOW_FLAG INITIATE_WORKFLOW_FLAG
FROM AP_HOLD_CODES AHC
, AP_LOOKUP_CODES L1
, AP_LOOKUP_CODES L2
WHERE AHC.HOLD_LOOKUP_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'HOLD CODE'
AND AHC.HOLD_TYPE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'HOLD TYPE'

Columns