View: EDW_POA_SPIM_SPLRITEM_LCV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.EDW_POA_SPIM_SPLRITEM_LCV

View Text

SELECT
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) GROUP BY SUPPLIER_ITEM_PK
, ALL_FK
, SUPPLIER_SITE_ITEM_DP
, SUPPLIER_ITEM_DP
, NAME
, SUPPLIER_SITE_CODE
, SUPPLIER_NAME
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5

Columns