APPS.AHL_MM_RESERVATIONS_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 57: FROM ahl_schedule_materials asmt, ahl_workorders aw, wip_discrete_jobs wdj

53: GROUP BY mr.demand_source_line_detail
54: ) reserved_quantity,
55: nvl(asmt.completed_quantity,0) completed_quantity, asmt.workorder_operation_id, asmt.operation_sequence,
56: aw.wip_entity_id,aw.workorder_id,wdj.project_id, wdj.task_id
57: FROM ahl_schedule_materials asmt, ahl_workorders aw, wip_discrete_jobs wdj
58: WHERE asmt.scheduled_material_id = c_scheduled_material_id
59: AND asmt.visit_task_id = aw.visit_task_id
60: AND aw.wip_entity_id = wdj.wip_entity_id
61: AND asmt.visit_id = aw.visit_id

Line 2950: FROM mtl_reservations mrsv, ahl_schedule_materials asmt

2946: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2947:
2948: CURSOR get_reservation_csr IS
2949: SELECT mrsv.reservation_id, mrsv.primary_reservation_quantity
2950: FROM mtl_reservations mrsv, ahl_schedule_materials asmt
2951: WHERE mrsv.demand_source_line_detail = p_scheduled_material_id
2952: AND mrsv.external_source_code = 'AHL'
2953: AND NVL(mrsv.subinventory_code, '@@@') = NVL(p_sub_inv_code, '@@@')
2954: AND NVL(mrsv.locator_id, -99) = NVL(p_locator_id, -99)