DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MRP_ATP_SCHEDULE_TEMP

Line 17236: from mrp_atp_schedule_temp

17232: BEGIN
17233: l_global_availability := 'Y';
17234: select 'x'
17235: into l_temp
17236: from mrp_atp_schedule_temp
17237: where session_id = p_session_id
17238: group by order_line_id
17239: having count(*) > 1;
17240: EXCEPTION

Line 18701: SELECT p_session_id ||':'||mrp_atp_schedule_temp_s.nextval,

18697:
18698: -- Get the demand_id from mrp_atp_details_temp
18699: BEGIN
18700: -- Bug 3444096, use x_atp_table.match_item_id for match cases in CTO
18701: SELECT p_session_id ||':'||mrp_atp_schedule_temp_s.nextval,
18702: DECODE(x_atp_table.Requested_Ship_Date(k),
18703: NULL, x_atp_table.Requested_Arrival_Date(k),
18704: x_atp_table.Requested_Ship_Date(k)),
18705: identifier3,