DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_SALES_ORDERS

Line 9949: --s_cto_rearch: For ODS based ATP, we should be updating msc_sales_orders

9945: -- of the demand which causes this planned order
9946: -- as well so that they can cancel each other.
9947:
9948: -- For bug 2259824, move the demand to the end of day
9949: --s_cto_rearch: For ODS based ATP, we should be updating msc_sales_orders
9950: IF p_plan_id = -1 THEN
9951: UPDATE msc_sales_orders
9952: SET REQUIREMENT_DATE = TRUNC(l_atp_date_this_level) --4460369+ MSC_ATP_PVT.G_END_OF_DAY
9953: WHERE sr_instance_id = p_atp_record.instance_id

Line 9951: UPDATE msc_sales_orders

9947:
9948: -- For bug 2259824, move the demand to the end of day
9949: --s_cto_rearch: For ODS based ATP, we should be updating msc_sales_orders
9950: IF p_plan_id = -1 THEN
9951: UPDATE msc_sales_orders
9952: SET REQUIREMENT_DATE = TRUNC(l_atp_date_this_level) --4460369+ MSC_ATP_PVT.G_END_OF_DAY
9953: WHERE sr_instance_id = p_atp_record.instance_id
9954: AND DEMAND_ID = l_demand_id
9955: returning inventory_item_id into l_inventory_item_id;