VIEW: APPS.AP_HOLDS_OVERVIEW_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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