[Home] [Help]
VIEW: APPS.POS_ASL_ITEM_LOV_V
Source
View Text - Preformatted
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
View Text - HTML Formatted
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