View: POA_BIS_SUPPLIER_PERFORMANCE_V

Product:	PO - Purchasing
Description:	This view is based on the POA_BIS_SUPPLIER_PERFORMANCE table. Please refer to the base view for further information.
Implementation/DBA Data:	APPS.POA_BIS_SUPPLIER_PERFORMANCE_V

View Text

SELECT PSP.PO_SHIPMENT_ID
, PSP.SHIP_TO_LOCATION_ID
, PSP.SHIP_TO_ORGANIZATION_ID
, PSP.ORG_ID
, PSP.ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION
, PSP.CATEGORY_ID
, PSP.SUPPLIER_ID
, PSP.SUPPLIER_SITE_ID
, POV.VENDOR_NAME
, PSP.BUYER_ID
, PSP.DATE_DIMENSION
, PSP.QUANTITY_PURCHASED
, PSP.PURCHASE_PRICE
, PSP.PRIMARY_UOM
, PSP.CURRENCY_CODE
, PSP.RATE_TYPE
, PSP.RATE_DATE
, PSP.RATE
, PSP.QUANTITY_ORDERED
, PSP.QUANTITY_RECEIVED
, PSP.QUANTITY_REJECTED
, PSP.AMOUNT
, PSP.NUMBER_OF_RECEIPTS
, PSP.QUANTITY_RECEIVED_LATE
, PSP.QUANTITY_RECEIVED_EARLY
, PSP.QUANTITY_PAST_DUE
, PSP.FIRST_RECEIPT_DATE
, PSP.SHIPMENT_EXPECTED_DATE
, PSP.MONTH_BUCKET
, PSP.QUARTER_BUCKET
, PSP.YEAR_BUCKET
, PSP.CREATED_BY
, PSP.CREATION_DATE
, PSP.LAST_UPDATE_DATE
, PSP.LAST_UPDATED_BY
, PSP.LAST_UPDATE_LOGIN
, PSP.REQUEST_ID
, PSP.PROGRAM_APPLICATION_ID
, PSP.PROGRAM_ID
, PSP.PROGRAM_UPDATE_DATE
FROM POA_BIS_SUPPLIER_PERFORMANCE PSP
, MTL_SYSTEM_ITEMS_KFV MSI
, PO_VENDORS POV
WHERE PSP.SUPPLIER_ID = POV.VENDOR_ID
AND MSI.INVENTORY_ITEM_ID = PSP.ITEM_ID
AND MSI.ORGANIZATION_ID = PSP.SHIP_TO_ORGANIZATION_ID

Columns