APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_SUPPLIER_HORIZONTAL_PLAN

Line 1: PACKAGE BODY msc_supplier_horizontal_plan AS

1: PACKAGE BODY msc_supplier_horizontal_plan AS
2: /* $Header: MSCHSPLB.pls 120.9 2007/01/17 19:20:32 hulu ship $ */
3:
4: SYS_YES CONSTANT INTEGER := 1;
5: SYS_NO CONSTANT INTEGER := 2;

Line 900: -- ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label('||l_supplier_site || '), '||

896: 'supplier_id, '||
897: 'supplier_site_id, '||
898: NODE_ITEM_SUPPLIER ||' , ' ||
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||') ' ||

Line 901: ',msc_get_name.supplier(supplier_id) || msc_supplier_horizontal_plan.get_order_type_label(supplier_site_id ), '||

897: 'supplier_site_id, '||
898: NODE_ITEM_SUPPLIER ||' , ' ||
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||') ' ||

Line 962: END msc_supplier_horizontal_plan;

958: FND_MESSAGE.set_name('MSC','MSC_Order_date_type');
959: return '('||FND_MESSAGE.get||': '||l_shipping_control||')';
960: END;
961:
962: END msc_supplier_horizontal_plan;