[Home] [Help]
View: EDW_POA_SPIM_SPLRITEM_FKV
Product: | PO - Purchasing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT POV.VENDOR_NAME || '-' || PVS.VENDOR_SITE_CODE || '-' || POL.VENDOR_PRODUCT_NUM
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, POL.VENDOR_PRODUCT_NUM
FROM PO_HEADERS_ALL POH
, PO_VENDORS POV
, PO_LINES_ALL POL
, PO_VENDOR_SITES_ALL PVS
WHERE POL.VENDOR_PRODUCT_NUM IS NOT NULL
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PVS.VENDOR_ID = POV.VENDOR_ID
Columns
Name |
SUPPLIER_ITEM_PK |
VENDOR_NAME |
VENDOR_SITE_ID |
VENDOR_SITE_CODE |
VENDOR_PRODUCT_NUM |