APPS.MSC_REL_WF dependencies on MSC_SALES_ORDER_INTERFACE

Line 1580: insert into msc_sales_order_interface

1576: ELSE
1577: p_original_item_id(a) := p_substitute_item_id(a);
1578: END IF;
1579:
1580: insert into msc_sales_order_interface
1581: (last_update_date,
1582: last_updated_by,
1583: creation_date,
1584: created_by,

Line 1658: from msc_sales_order_interface

1654: EXIT WHEN instance_cur%NOTFOUND;
1655: v_temp :=0;
1656: select count(*)
1657: into v_temp
1658: from msc_sales_order_interface
1659: where sr_instance_id = p_inst_id
1660: and batch_id = v_batch_id;
1661: if v_temp > 0 then
1662: arg_so_rel_id.extend(1);

Line 1681: UPDATE msc_sales_order_interface

1677: CLOSE crm_cur;
1678:
1679: -- if customer_id is null but order_number not ends with 'CMRO',
1680: -- it is not a CMRO
1681: UPDATE msc_sales_order_interface
1682: set source_type = null,
1683: quantity = null
1684: where source_type =100 -- customer_id is null
1685: and order_number not like '%'||crm_char

Line 3447: msc_sales_order_interface msoi

3443: orig_item_desc
3444: from msc_system_items msi,
3445: msc_plans mp,
3446: msc_demands md,
3447: msc_sales_order_interface msoi
3448: where msoi.batch_id = p_batch_id
3449: and msoi.sr_instance_id = p_instance_id
3450: and msoi.plan_id = md.plan_id
3451: and msoi.demand_id = md.demand_id