DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_SALES_ORDERS

Line 2136: from msc_sales_orders

2132: AND dem.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID ;
2133:
2134: cursor c_so_number is
2135: select sales_order_number
2136: from msc_sales_orders
2137: where sr_instance_id = p_inst_id
2138: and demand_id = p_demand_id;
2139:
2140: l_order_number varchar2(200);

Line 3098: from msc_sales_orders

3094: p_so_line_id in number,
3095: p_set_type in number) return varchar2 IS
3096: CURSOR set_c is
3097: select decode(p_set_type, 1, ship_set_name, arrival_set_name)
3098: from msc_sales_orders
3099: where sr_instance_id = p_inst_id
3100: and demand_source_line = p_so_line_id;
3101: v_set_name varchar2(30);
3102: BEGIN