DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_SALES_ORDERS

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

9240: -- of the demand which causes this planned order
9241: -- as well so that they can cancel each other.
9242:
9243: -- For bug 2259824, move the demand to the end of day
9244: --s_cto_rearch: For ODS based ATP, we should be updating msc_sales_orders
9245: IF p_plan_id = -1 THEN
9246: UPDATE msc_sales_orders
9247: SET REQUIREMENT_DATE = TRUNC(l_atp_date_this_level) --4460369+ MSC_ATP_PVT.G_END_OF_DAY
9248: WHERE sr_instance_id = p_atp_record.instance_id

Line 9246: UPDATE msc_sales_orders

9242:
9243: -- For bug 2259824, move the demand to the end of day
9244: --s_cto_rearch: For ODS based ATP, we should be updating msc_sales_orders
9245: IF p_plan_id = -1 THEN
9246: UPDATE msc_sales_orders
9247: SET REQUIREMENT_DATE = TRUNC(l_atp_date_this_level) --4460369+ MSC_ATP_PVT.G_END_OF_DAY
9248: WHERE sr_instance_id = p_atp_record.instance_id
9249: AND DEMAND_ID = l_demand_id
9250: returning inventory_item_id into l_inventory_item_id;