APPS.AHL_LTP_REQST_MATRL_PVT dependencies on MTL_RESERVATIONS

Line 908: FROM mtl_reservations MR,

904: IF l_planned_materials_tbl(i).inventory_item_id <> l_Planned_Items_rec.inventory_item_id
905: THEN
906: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
907: INTO l_rsvd_quantity
908: FROM mtl_reservations MR,
909: ahl_schedule_materials SM
910: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
911: AND MR.external_source_code = 'AHL'
912: AND MR.demand_source_line_detail = SM.scheduled_material_id

Line 917: -- This is based on PRIMARY_RESERVATION_QUANTITY is not null in mtl_reservations

913: AND MR.organization_id = SM.organization_id
914: AND MR.requirement_date = SM.requested_date
915: AND MR.inventory_item_id = SM.inventory_item_id;
916:
917: -- This is based on PRIMARY_RESERVATION_QUANTITY is not null in mtl_reservations
918: IF l_rsvd_quantity IS NOT NULL THEN
919: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_RSV_EXISTS' );
920: -- Cannot change the item required because at least one reservation already exists for this item.
921: FND_MSG_PUB.add;

Line 950: FROM mtl_reservations MR,

946: IF NVL(l_planned_materials_tbl(i).quantity,-9) <> NVL(l_Planned_Items_rec.requested_quantity,-99)
947: THEN
948: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
949: INTO l_rsvd_quantity
950: FROM mtl_reservations MR,
951: ahl_schedule_materials SM
952: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
953: AND MR.external_source_code = 'AHL'
954: AND MR.demand_source_line_detail = SM.scheduled_material_id

Line 3040: FROM mtl_reservations RSV

3036: WHERE vt.visit_id = c_visit_id
3037: AND vt.status_code = 'DELETED'
3038: AND vt.visit_task_id = mat.visit_task_id
3039: AND EXISTS (SELECT reservation_id
3040: FROM mtl_reservations RSV
3041: WHERE RSV.external_source_code = 'AHL'
3042: AND RSV.demand_source_line_detail = mat.scheduled_material_id
3043: AND RSV.organization_id = mat.organization_id
3044: AND RSV.requirement_date = mat.requested_date

Line 3054: FROM mtl_reservations

3050: WHERE visit_id = p_visit_id;
3051:
3052: CURSOR get_prev_org_csr(p_visit_id IN NUMBER) IS
3053: SELECT organization_id
3054: FROM mtl_reservations
3055: WHERE external_source_code = 'AHL'
3056: AND demand_source_header_id in ( SELECT visit_task_id
3057: FROM ahl_visit_tasks_b
3058: WHERE visit_id = p_visit_id);

Line 3092: FROM mtl_reservations

3088:
3089:
3090: SELECT count(distinct organization_id)
3091: INTO l_org_count
3092: FROM mtl_reservations
3093: WHERE external_source_code = 'AHL'
3094: AND demand_source_header_id in ( SELECT visit_task_id
3095: FROM ahl_visit_tasks_b
3096: WHERE visit_id = p_visit_id);