FND Design Data [Home] [Help]

View: MSC_PUBLISH_ITEMS_LOV_V

Product: MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data: ViewAPPS.MSC_PUBLISH_ITEMS_LOV_V
View Text

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

Columns

Name
PLAN_ID
INVENTORY_ITEM_ID
ITEM_NAME