DBA Data[Home] [Help]

VIEW: APPS.MSC_PUBLISH_ITEMS_LOV_V

Source

View Text - Preformatted

SELECT distinct i.plan_id, i.inventory_item_id, i.item_name from msc_system_items i, msc_supplies s WHERE i.plan_id = s.plan_id and i.inventory_item_id = s.inventory_item_id
View Text - HTML Formatted

SELECT DISTINCT I.PLAN_ID
, I.INVENTORY_ITEM_ID
, I.ITEM_NAME
FROM MSC_SYSTEM_ITEMS I
, MSC_SUPPLIES S
WHERE I.PLAN_ID = S.PLAN_ID
AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID