VIEW: APPS.POA_BIS_SUPPLIER_PERFORMANCE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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