APPS.AHL_LTP_REQST_MATRL_PVT dependencies on MTL_RESERVATIONS

Line 919: FROM mtl_reservations MR,

915: IF l_planned_materials_tbl(i).inventory_item_id <> l_Planned_Items_rec.inventory_item_id
916: THEN
917: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
918: INTO l_rsvd_quantity
919: FROM mtl_reservations MR,
920: ahl_schedule_materials SM
921: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
922: AND MR.external_source_code = 'AHL'
923: AND MR.demand_source_line_detail = SM.scheduled_material_id

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

924: AND MR.organization_id = SM.organization_id
925: AND MR.requirement_date = SM.requested_date
926: AND MR.inventory_item_id = SM.inventory_item_id;
927:
928: -- This is based on PRIMARY_RESERVATION_QUANTITY is not null in mtl_reservations
929: IF l_rsvd_quantity IS NOT NULL THEN
930: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_RSV_EXISTS' );
931: -- Cannot change the item required because at least one reservation already exists for this item.
932: FND_MSG_PUB.add;

Line 961: FROM mtl_reservations MR,

957: IF NVL(l_planned_materials_tbl(i).quantity,-9) <> NVL(l_Planned_Items_rec.requested_quantity,-99)
958: THEN
959: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
960: INTO l_rsvd_quantity
961: FROM mtl_reservations MR,
962: ahl_schedule_materials SM
963: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
964: AND MR.external_source_code = 'AHL'
965: AND MR.demand_source_line_detail = SM.scheduled_material_id

Line 3109: FROM mtl_reservations RSV

3105: WHERE vt.visit_id = c_visit_id
3106: AND vt.status_code = 'DELETED'
3107: AND vt.visit_task_id = mat.visit_task_id
3108: AND EXISTS (SELECT reservation_id
3109: FROM mtl_reservations RSV
3110: WHERE RSV.external_source_code = 'AHL'
3111: AND RSV.demand_source_line_detail = mat.scheduled_material_id
3112: AND RSV.organization_id = mat.organization_id
3113: AND RSV.requirement_date = mat.requested_date

Line 3123: FROM mtl_reservations

3119: WHERE visit_id = p_visit_id;
3120:
3121: CURSOR get_prev_org_csr(p_visit_id IN NUMBER) IS
3122: SELECT organization_id
3123: FROM mtl_reservations
3124: WHERE external_source_code = 'AHL'
3125: AND demand_source_header_id in ( SELECT visit_task_id
3126: FROM ahl_visit_tasks_b
3127: WHERE visit_id = p_visit_id);

Line 3161: FROM mtl_reservations

3157:
3158:
3159: SELECT count(distinct organization_id)
3160: INTO l_org_count
3161: FROM mtl_reservations
3162: WHERE external_source_code = 'AHL'
3163: AND demand_source_header_id in ( SELECT visit_task_id
3164: FROM ahl_visit_tasks_b
3165: WHERE visit_id = p_visit_id);