APPS.MSC_GET_NAME dependencies on MSC_SALES_ORDERS

Line 145: FROM msc_sales_orders

141: FUNCTION CUSTOMER_PO_NUMBER (arg_demand_id IN NUMBER,
142: arg_sr_instance_id IN NUMBER) return varchar2 is
143: CURSOR customer_po_number_c IS
144: SELECT cust_po_number
145: FROM msc_sales_orders
146: WHERE demand_id = arg_demand_id
147: AND sr_instance_id = arg_sr_instance_id;
148: l_customer_po_number varchar2(50);
149: begin

Line 165: FROM msc_sales_orders

161: arg_sr_instance_id IN NUMBER) return varchar2 is
162:
163: CURSOR customer_po_line_number_c IS
164: SELECT customer_line_number
165: FROM msc_sales_orders
166: WHERE demand_id = arg_demand_id
167: AND sr_instance_id = arg_sr_instance_id;
168:
169: l_customer_po_line_number varchar2(50);

Line 2538: from msc_sales_orders

2534: AND dem.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID ;
2535:
2536: cursor c_so_number is
2537: select sales_order_number
2538: from msc_sales_orders
2539: where sr_instance_id = p_inst_id
2540: and demand_id = p_demand_id;
2541:
2542: l_order_number varchar2(200);

Line 3526: from msc_sales_orders

3522: p_so_line_id in number,
3523: p_set_type in number) return varchar2 IS
3524: CURSOR set_c is
3525: select decode(p_set_type, 1, ship_set_name, arrival_set_name)
3526: from msc_sales_orders
3527: where sr_instance_id = p_inst_id
3528: and demand_source_line = p_so_line_id;
3529: v_set_name varchar2(30);
3530: BEGIN

Line 6444: from msc_sales_orders mso

6440: arg_sr_instance_id IN NUMBER) return varchar2 IS
6441:
6442: CURSOR get_ship_set is
6443: select mso.ship_set_name
6444: from msc_sales_orders mso
6445: where mso.demand_id = arg_demand_id
6446: and mso.sr_instance_id = arg_sr_instance_id;
6447:
6448: var_ship_set_name varchar2(240);