[Home] [Help]
View: MSC_VMI_ITEM_V
Product: | MSC - Advanced Supply Chain Planning |
Description: | |
Implementation/DBA Data: |
APPS.MSC_VMI_ITEM_V
|
View Text
SELECT DISTINCT I.PLAN_ID
, I.SR_INSTANCE_ID
, I.ORGANIZATION_ID
, I.INVENTORY_ITEM_ID
, I.SUPPLIER_ID
, I.SUPPLIER_SITE_ID
, S.ITEM_NAME
, I.PLANNER_CODE
FROM MSC_ITEM_SUPPLIERS I
, MSC_ITEMS S
WHERE I.PLAN_ID = -1
AND I.VMI_FLAG = 1
AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
Columns
Name |
PLAN_ID |
SR_INSTANCE_ID |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
SUPPLIER_ID |
SUPPLIER_SITE_ID |
ITEM_NAME |
PLANNER_CODE |