APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_ITEM_SUPPLIERS

Line 81: msc_item_suppliers items,

77: FROM
78: msc_trading_partners mtp,
79: msc_calendar_dates cal,
80: msc_supplier_capacities cap,
81: msc_item_suppliers items,
82: msc_form_query list
83: WHERE
84: cap.supplier_id = list.number2
85: AND NVL(cap.supplier_site_id,-1) = NVL(list.number5,-1)

Line 758: msc_item_suppliers s

754: cursor config_list (p_base_item NUMBER,
755: l_supplier_id NUMBER)is
756: select distinct i.inventory_item_id
757: from msc_system_items i,
758: msc_item_suppliers s
759: where i.base_item_id = p_base_item
760: and i.plan_id = p_plan_id
761: and i.bom_item_type = 4
762: and i.inventory_item_id = s.inventory_item_id

Line 903: 'FROM msc_item_suppliers '||

899: l_base_item|| -- base_ato in case of config
900: -- ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label('||l_supplier_site || '), '||
901: ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label(supplier_site_id ), '||
902: 'msc_get_name.item_name(' ||l_base_item|| ' ,null,null,null) '||
903: 'FROM msc_item_suppliers '||
904: 'WHERE inventory_item_id in ('||l_item_list||') ' ||
905: 'AND supplier_id in ('||p_supplier_list||') ' ||
906: -- 'AND NVL(supplier_site_id,-1) in ('||l_supplier_site||') ' ||
907: 'and using_organization_id = -1 AND plan_id = '||p_plan_id;