APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_ITEM_SUPPLIERS

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 393: FROM msc_item_suppliers

389: --vmi_unit_of_measure,
390: processing_lead_time,
391: --average_daily_demand AS average_daily_usage,
392: replenishment_method,fixed_order_quantity
393: FROM msc_item_suppliers
394: WHERE plan_id = -1
395: and sr_instance_id = p_sr_instance_id
396: and organization_id = p_organization_id
397: and inventory_item_id = p_inventory_item_id

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;

Line 1854: FROM msc_item_suppliers i, msc_items s, msc_trading_partners tp, msc_trading_partner_maps map_cust, msc_company_sites cust_site,

1850:
1851: CURSOR item_suppliers_cur is
1852: SELECT nvl(i.min_minmax_quantity,0) min_minmax_quantity, nvl(i.max_minmax_quantity,0) max_minmax_quantity,
1853: i.processing_lead_time AS processing_lead_time
1854: FROM msc_item_suppliers i, msc_items s, msc_trading_partners tp, msc_trading_partner_maps map_cust, msc_company_sites cust_site,
1855: msc_trading_partner_maps map_supp, msc_company_sites supp_site, msc_trading_partner_maps map_rel,
1856: msc_company_relationships rel
1857: WHERE i.plan_id = -1
1858: -- AND i.vmi_flag = 1

Line 2554: FROM msc_item_suppliers mis

2550: IS
2551: SELECT nvl(forecast_horizon,0) forecast_horizon, nvl(min_minmax_quantity,0) min_minmax_quantity, nvl(max_minmax_quantity,
2552: 0) max_minmax_quantity,nvl(min_minmax_days,0) min_minmax_days ,nvl(max_minmax_days,0) max_minmax_days,nvl(fixed_order_quantity,0) fixed_order_quantity, replenishment_method,
2553: nvl(processing_lead_time,0) processing_lead_time
2554: FROM msc_item_suppliers mis
2555: WHERE mis.inventory_item_id = p_inventory_item_id
2556: AND mis.plan_id = p_plan_id
2557: AND mis.sr_instance_id = p_sr_instance_id
2558: AND mis.organization_id = p_organization_id