View: AP_HOLDS_OVERVIEW_V

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

View Text

SELECT AH.ROWID ROW_ID
, AH.ATTRIBUTE1 ATTRIBUTE1
, AH.ATTRIBUTE10 ATTRIBUTE10
, AH.ATTRIBUTE11 ATTRIBUTE11
, AH.ATTRIBUTE12 ATTRIBUTE12
, AH.ATTRIBUTE13 ATTRIBUTE13
, AH.ATTRIBUTE14 ATTRIBUTE14
, AH.ATTRIBUTE15 ATTRIBUTE15
, AH.ATTRIBUTE2 ATTRIBUTE2
, AH.ATTRIBUTE3 ATTRIBUTE3
, AH.ATTRIBUTE4 ATTRIBUTE4
, AH.ATTRIBUTE5 ATTRIBUTE5
, AH.ATTRIBUTE6 ATTRIBUTE6
, AH.ATTRIBUTE7 ATTRIBUTE7
, AH.ATTRIBUTE8 ATTRIBUTE8
, AH.ATTRIBUTE9 ATTRIBUTE9
, AH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AH.CREATED_BY CREATED_BY
, AH.CREATION_DATE CREATION_DATE
, AH.HELD_BY HELD_BY
, AH.HOLD_DATE HOLD_DATE
, AH.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE
, AH.HOLD_REASON HOLD_REASON
, AH.INVOICE_ID INVOICE_ID
, AH.LAST_UPDATED_BY LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AH.LINE_LOCATION_ID LINE_LOCATION_ID
, AH.RELEASE_LOOKUP_CODE RELEASE_LOOKUP_CODE
, AH.RELEASE_REASON RELEASE_REASON
, AH.STATUS_FLAG STATUS_FLAG
, AH.RESPONSIBILITY_ID RESPONSIBILITY_ID
, AH.ORG_ID ORG_ID
, ALC1.DISPLAYED_FIELD HOLD_NAME
, ALC2.DISPLAYED_FIELD HOLD_TYPE
, AI.INVOICE_NUM INVOICE_NUM
, FU.USER_NAME HELD_BY_USER_NAME
, PLL.PO_HEADER_ID PO_HEADER_ID
, PLL.PO_LINE_ID PO_LINE_ID
, PLL.QUANTITY QUANTITY
FROM AP_HOLDS AH
, AP_HOLD_CODES AHC
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_INVOICES_ALL AI
, FND_USER FU
, PO_LINE_LOCATIONS_ALL PLL
WHERE AH.HOLD_LOOKUP_CODE = AHC.HOLD_LOOKUP_CODE
AND ALC1.LOOKUP_TYPE = 'HOLD CODE'
AND ALC1.LOOKUP_CODE = AH.HOLD_LOOKUP_CODE
AND ALC2.LOOKUP_TYPE = 'HOLD TYPE'
AND ALC2.LOOKUP_CODE = AHC.HOLD_TYPE
AND AH.INVOICE_ID = AI.INVOICE_ID
AND AH.HELD_BY = FU.USER_ID (+)
AND AH.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID (+)
AND AH.RELEASE_REASON IS NULL

Columns