VIEW: APPS.AP_HOLD_CODES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'