APPS.MSC_ATP_PUB dependencies on MRP_ATP_DETAILS_TEMP

Line 2595: from mrp_atp_details_temp

2591: IF NVL( FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N') = 'Y' THEN
2592: BEGIN
2593: select summary_flag
2594: into l_summary_flag
2595: from mrp_atp_details_temp
2596: where session_id = p_session_id
2597: and summary_flag = 'Y'
2598: and record_type = 3 --record_type check added for performance
2599: and rownum = 1;

Line 2904: mrp_atp_details_temp madt

2900: p.latest_refresh_number))
2901: into l_end_refresh_number
2902: from msc_plans p,
2903: msc_demands d,
2904: mrp_atp_details_temp madt
2905: where d.plan_id = p.plan_id
2906: and d.refresh_number = p_refresh_number
2907: and d.plan_id = madt.identifier2
2908: and d.demand_id = madt.identifier3

Line 2944: FROM MRP_ATP_DETAILS_TEMP

2940: BULK COLLECT INTO
2941: l_identifier2,
2942: l_identifier3,
2943: l_identifier1
2944: FROM MRP_ATP_DETAILS_TEMP
2945: where session_id = p_session_id
2946: and record_type = 3
2947: and NVL(identifier2, -1) > 0
2948: and identifier3 is not NULL

Line 3044: from mrp_atp_details_temp

3040: and (plan_id, demand_id, sr_instance_id) in
3041: ( select identifier2,
3042: identifier3,
3043: identifier1
3044: from mrp_atp_details_temp
3045: where session_id = p_session_id
3046: and supply_demand_type = 1
3047: and record_type = 3
3048: and NVL(identifier2, -1) > 0