[Home] [Help]
View: POS_ASL_ITEM_LOV_V
View Text
SELECT DISTINCT(MSI.SEGMENT1)
, MSI.DESCRIPTION
, ASLATT.ITEM_ID
, ASLATT.VENDOR_SITE_ID
FROM PO_ASL_ATTRIBUTES ASLATT
, MTL_SYSTEM_ITEMS MSI
WHERE ASLATT.ITEM_ID = MSI.INVENTORY_ITEM_ID
Columns
Name |
SEGMENT1 |
DESCRIPTION |
ITEM_ID |
VENDOR_SITE_ID |