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 769: msc_item_suppliers s

765: cursor config_list (p_base_item NUMBER,
766: l_supplier_id NUMBER)is
767: select distinct i.inventory_item_id
768: from msc_system_items i,
769: msc_item_suppliers s
770: where i.base_item_id = p_base_item
771: and i.plan_id = p_plan_id
772: and i.bom_item_type = 4
773: and i.inventory_item_id = s.inventory_item_id

Line 914: 'FROM msc_item_suppliers '||

910: l_base_item|| -- base_ato in case of config
911: -- ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label('||l_supplier_site || '), '||
912: ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label(supplier_site_id ), '||
913: 'msc_get_name.item_name(' ||l_base_item|| ' ,null,null,null) '||
914: 'FROM msc_item_suppliers '||
915: 'WHERE inventory_item_id in ('||l_item_list||') ' ||
916: 'AND supplier_id in ('||p_supplier_list||') ' ||
917: -- 'AND NVL(supplier_site_id,-1) in ('||l_supplier_site||') ' ||
918: 'and using_organization_id = -1 AND plan_id = '||p_plan_id;