APPS.AHL_INV_RESERVATIONS_GRP dependencies on AHL_SCHEDULE_MATERIALS

Line 61: FROM ahl_schedule_materials

57: CURSOR get_mtl_dtls_cur (c_scheduled_material_id IN NUMBER)
58: IS
59: SELECT requested_quantity,
60: NVL(completed_quantity, 0) completed_quantity
61: FROM ahl_schedule_materials
62: WHERE scheduled_material_id = c_scheduled_material_id;
63:
64: -- cursor to get the reserved quantity from the WMS tables
65: CURSOR get_rsvd_qty_csr(c_scheduled_material_id IN NUMBER)

Line 68: FROM mtl_reservations mrsv,ahl_schedule_materials asmt

64: -- cursor to get the reserved quantity from the WMS tables
65: CURSOR get_rsvd_qty_csr(c_scheduled_material_id IN NUMBER)
66: IS
67: SELECT SUM(primary_reservation_quantity) reserved_quantity
68: FROM mtl_reservations mrsv,ahl_schedule_materials asmt
69: WHERE mrsv.demand_source_line_detail = c_scheduled_material_id
70: AND mrsv.external_source_code = 'AHL'
71: AND mrsv.demand_source_line_detail = asmt.scheduled_material_id
72: AND mrsv.organization_id = asmt.organization_id

Line 278: FROM ahl_schedule_materials

274: c_organization_id IN NUMBER,
275: c_item_id IN NUMBER)
276: IS
277: SELECT scheduled_material_id
278: FROM ahl_schedule_materials
279: WHERE scheduled_material_id = c_SCHEDULED_MATERIAL_ID
280: AND organization_id = c_organization_ID
281: AND inventory_item_id = c_item_ID
282: AND visit_task_id = c_visit_task_ID

Line 298: FROM ahl_schedule_materials

294: c_organization_id IN NUMBER,
295: c_item_id IN NUMBER)
296: IS
297: SELECT scheduled_material_id
298: FROM ahl_schedule_materials
299: WHERE scheduled_material_id = c_scheduled_material_id
300: AND organization_id = c_organization_id
301: AND inventory_item_id = c_item_id
302: AND Operation_sequence = c_oper_seq_num