APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_AVAILABLE_TO_PROMISE

Line 2918: mrp_available_to_promise avail

2914: avail.schedule_date old_date,
2915: avail.quantity_available new_quantity,
2916: 0 old_quantity
2917: FROM mrp_form_query list,
2918: mrp_available_to_promise avail
2919: WHERE avail.schedule_date < last_date
2920: AND avail.organization_id = list.number2
2921: AND avail.compile_designator = list.char1
2922: AND avail.inventory_item_id = list.number1