APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_DEMANDS

Line 70: p_source_table ='MSC_DEMANDS') then

66: p_impl_as := 5;
67: elsif p_order_type = 78 then
68: p_impl_as := 2;
69: elsif (p_order_type = 53 and p_plan_type = 5 and
70: p_source_table ='MSC_DEMANDS') then
71: -- Planned Outbound Shipment in DRP plan
72: if p_supplier_id is not null then
73: p_impl_as := 2;
74: elsif p_dest_inst_id <> p_sr_instance_id then

Line 623: update msc_demands

619: END update_sup_rel_error;
620:
621: Procedure update_dmd_rel_error IS
622: BEGIN
623: update msc_demands
624: set release_errors = p_rel_error,
625: implement_org_id = null,
626: implement_instance_id = null,
627: implement_date = NULL,

Line 650: update msc_demands

646: BEGIN
647: msc_rel_wf.update_so_dates(p_plan_id, p_transaction_id, p_inst_id,
648: p_impl_date, v_ship_date, v_arrival_date,
649: v_earliest_date);
650: update msc_demands
651: set implement_org_id = organization_id,
652: implement_instance_id = sr_instance_id,
653: implement_date = nvl(implement_date,planned_ship_date),
654: implement_ship_date = v_ship_date,

Line 775: ' OR (order_type = 53 and source_table = ''MSC_DEMANDS'') ) ' ||

771: ' from MSC_ORDERS_DRP_V'||
772: ' where ' || p_where_clause ||
773: ' and ( (order_type IN (1, 2, 3, 5, 13, 51, 53, 76,77,78)'||
774: ' and source_table = ''MSC_SUPPLIES'' ) ' ||
775: ' OR (order_type = 53 and source_table = ''MSC_DEMANDS'') ) ' ||
776: ' and nvl(release_time_fence_code,-1) <> 7 ' ||
777: p_plan_id_str ||
778: ' and nvl(release_status,2) = 2';
779:

Line 851: ' and source_table = ''MSC_DEMANDS'''||

847: 'from msc_orders_v mo' ||
848: ' where ' || p_where_clause ||
849: ' and nvl(release_status,2) = 2' ||
850: ' and order_type = 30'||
851: ' and source_table = ''MSC_DEMANDS'''||
852: ' and exists (select 1 from msc_exception_details med ' ||
853: ' where med.plan_id = mo.plan_id ' ||
854: ' and med.exception_type = 70 ' ||
855: ' and med.organization_id = mo.organization_id '||