APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_SYSTEM_ITEMS

Line 51: -- ITEM ATTRIBUTES from msc_item_suppliers/msc_system_items --

47: -- 12 last receipt's quantity 38 --
48: -- OTHER: --
49: -- 13 what graph (gif name) 12 --
50: -- gif file name --
51: -- ITEM ATTRIBUTES from msc_item_suppliers/msc_system_items --
52: -- 14 inventory_planning_code 38 --
53: -- 15 reorder_point 38 --
54: -- 16 economic_order_quantity 38 --
55: -- 17 average_daily_usage 38 --

Line 412: msc_system_items item

408: --average_daily_usage,
409: uom_code,
410: item_name
411: FROM
412: msc_system_items item
413: WHERE plan_id = -1
414: and sr_instance_id = p_sr_instance_id
415: and organization_id = p_organization_id
416: and inventory_item_id = p_inventory_item_id;

Line 1302: FROM msc_system_items msi

1298: INTO l_min_minmax_qty, l_min_minmax_days, l_max_minmax_qty, l_max_minmax_days,
1299: l_so_authorization_flag, l_asn_auto_expire, l_consigned,
1300: l_fixed_order_quantity,l_supplier_uom_code, l_item_name, l_lead_time,l_forecast_horizon,
1301: l_source_org_id
1302: FROM msc_system_items msi
1303: WHERE msi.inventory_item_id = p_inventory_item_id
1304: AND msi.organization_id = p_organization_id
1305: AND msi.sr_instance_id = p_sr_instance_id
1306: AND msi.plan_id = -1;

Line 1568: -- ITEM ATTRIBUTES from msc_item_suppliers/msc_system_items

1564: l_last_receipt_date DATE;
1565: l_last_receipt_qty NUMBER;
1566: -- OTHER
1567: l_graph_name VARCHAR2(20);
1568: -- ITEM ATTRIBUTES from msc_item_suppliers/msc_system_items
1569: l_inventory_planning_code VARCHAR2(20);
1570:
1571: l_reorder_point NUMBER;
1572: l_economic_order_quantity NUMBER;