VIEW: APPS.MSC_VMI_ITEM_V

Source

View Text - Preformatted

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, s.description, msi.planner_code, MSC_X_UTIL.GET_BUYER_CODE(i.inventory_item_id,i.organization_id,i.sr_instance_id) from msc_item_suppliers i, msc_items s, msc_system_items msi WHERE i.plan_id = -1 and i.vmi_flag = 1 and i.inventory_item_id = s.inventory_item_id and msi.plan_id = -1 and msi.organization_id =i.organization_id and msi.sr_instance_id =i.sr_instance_id and msi.inventory_item_id = i.inventory_item_id

View Text - HTML Formatted

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
, S.DESCRIPTION
, MSI.PLANNER_CODE
, MSC_X_UTIL.GET_BUYER_CODE(I.INVENTORY_ITEM_ID
, I.ORGANIZATION_ID
, I.SR_INSTANCE_ID)
FROM MSC_ITEM_SUPPLIERS I
, MSC_ITEMS S
, MSC_SYSTEM_ITEMS MSI
WHERE I.PLAN_ID = -1
AND I.VMI_FLAG = 1
AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
AND MSI.PLAN_ID = -1
AND MSI.ORGANIZATION_ID =I.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID =I.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID