eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATION_AVAIL_PVT dependencies on MTL_RESERVATIONS

Line 335: FROM mtl_reservations

331: IF (l_wip_entity_type = inv_reservation_global.g_wip_source_type_fpo OR
332: l_wip_entity_type = inv_reservation_global.g_wip_source_type_batch) THEN
333: SELECT nvl(sum(primary_reservation_quantity), 0)
334: INTO l_primary_reserved_quantity
335: FROM mtl_reservations
336: WHERE supply_source_type_id = p_supply_source_type_id
337: AND supply_source_header_id = p_supply_source_header_id
338: AND supply_source_line_id = p_supply_source_line_id;
339: ELSE

Line 342: FROM mtl_reservations

338: AND supply_source_line_id = p_supply_source_line_id;
339: ELSE
340: SELECT nvl(sum(primary_reservation_quantity), 0)
341: INTO l_primary_reserved_quantity
342: FROM mtl_reservations
343: WHERE supply_source_type_id = p_supply_source_type_id
344: AND supply_source_header_id = p_supply_source_header_id;
345: END IF;
346: -- BUG 5052424 END

Line 473: FROM mtl_reservations

469: -- get the sum of quantity that is already reserved on the document.
470: BEGIN
471: SELECT nvl(sum(primary_reservation_quantity), 0)
472: INTO l_primary_reserved_quantity
473: FROM mtl_reservations
474: WHERE supply_source_type_id = p_supply_source_type_id
475: AND supply_source_header_id = p_supply_source_header_id
476: AND supply_source_line_id = p_supply_source_line_id
477: AND nvl(project_id, -99) = nvl(p_project_id, -99)

Line 495: FROM mtl_reservations

491: -- get the sum of quantity that is already reserved on the document.
492: BEGIN
493: SELECT nvl(sum(primary_reservation_quantity), 0)
494: INTO l_primary_reserved_quantity
495: FROM mtl_reservations
496: WHERE supply_source_type_id = p_supply_source_type_id
497: AND supply_source_header_id = p_supply_source_header_id
498: AND supply_source_line_id = p_supply_source_line_id
499: AND supply_source_line_detail = p_supply_source_line_detail

Line 600: FROM mtl_reservations

596: -- get the sum of quantity that is already reserved on the document.
597: BEGIN
598: SELECT nvl(sum(primary_reservation_quantity), 0)
599: INTO l_primary_reserved_quantity
600: FROM mtl_reservations
601: WHERE supply_source_type_id = p_supply_source_type_id
602: AND organization_id = p_organization_id
603: AND inventory_item_id = p_item_id
604: AND demand_source_type_id <> 5;-- bug 9706800: Consider reservations only for Sales Order and not for WIP Jobs/OPM batches since MOL quantity

Line 829: FROM mtl_reservations

825:
826: CURSOR rsv_with_lots IS
827: SELECT organization_id, inventory_item_id, lot_number,
828: primary_uom_code, primary_reservation_quantity, reservation_uom_code
829: FROM mtl_reservations
830: WHERE demand_source_type_id = p_demand_source_type_id
831: AND demand_source_header_id = p_demand_source_header_id
832: AND demand_source_line_id = p_demand_source_line_id
833: AND demand_source_line_detail is null

Line 951: FROM mtl_reservations

947: -- for cmro demand.
948: BEGIN
949: SELECT nvl(sum(primary_reservation_quantity), 0)
950: INTO l_primary_reserved_quantity
951: FROM mtl_reservations
952: WHERE demand_source_type_id = p_demand_source_type_id
953: AND demand_source_header_id = p_demand_source_header_id
954: AND demand_source_line_id = p_demand_source_line_id
955: AND demand_source_line_detail = p_demand_source_line_detail;

Line 1014: FROM mtl_reservations

1010: -- get the sum of quantity that is already reserved on the document.
1011: BEGIN
1012: SELECT nvl(sum(primary_reservation_quantity), 0)
1013: INTO l_primary_reserved_quantity
1014: FROM mtl_reservations
1015: WHERE demand_source_type_id = p_demand_source_type_id
1016: AND demand_source_header_id = p_demand_source_header_id
1017: AND demand_source_line_id = p_demand_source_line_id;
1018: EXCEPTION

Line 1099: FROM mtl_reservations

1095: BEGIN
1096: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
1097: ,nvl(sum(secondary_reservation_quantity), 0)
1098: INTO l_wdd_primary_reserved_qty, l_rsv_primary_uom_code, l_wdd_secondary_reserved_qty
1099: FROM mtl_reservations
1100: WHERE demand_source_type_id = p_demand_source_type_id
1101: AND demand_source_header_id = p_demand_source_header_id
1102: AND demand_source_line_id = p_demand_source_line_id
1103: AND demand_source_line_detail = p_demand_source_line_detail

Line 1129: FROM mtl_reservations

1125: BEGIN
1126: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
1127: ,nvl(sum(secondary_reservation_quantity), 0)
1128: INTO l_primary_reserved_quantity, l_rsv_primary_uom_code ,l_secondary_reserved_quantity
1129: FROM mtl_reservations
1130: WHERE demand_source_type_id = p_demand_source_type_id
1131: AND demand_source_header_id = p_demand_source_header_id
1132: AND demand_source_line_id = p_demand_source_line_id
1133: GROUP BY primary_uom_code;

Line 1163: FROM mtl_reservations

1159: BEGIN
1160: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
1161: ,nvl(sum(secondary_reservation_quantity), 0)
1162: INTO l_primary_reserved_quantity, l_rsv_primary_uom_code ,l_secondary_reserved_quantity
1163: FROM mtl_reservations
1164: WHERE demand_source_type_id = p_demand_source_type_id
1165: AND demand_source_header_id = p_demand_source_header_id
1166: AND demand_source_line_id = p_demand_source_line_id
1167: AND lot_number IS NULL --Bug 12978409

Line 1333: FROM mtl_reservations

1329: BEGIN
1330: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
1331: ,nvl(sum(secondary_reservation_quantity), 0)
1332: INTO l_primary_reserved_quantity, l_rsv_primary_uom_code ,l_secondary_reserved_quantity
1333: FROM mtl_reservations
1334: WHERE demand_source_type_id = p_demand_source_type_id
1335: AND demand_source_header_id = p_demand_source_header_id
1336: AND demand_source_line_id = p_demand_source_line_id
1337: AND demand_source_line_detail is null

Line 1532: AND NOT EXISTS (SELECT 1 FROM MTL_RESERVATIONS MR

1528: FROM oe_order_lines_all
1529: WHERE line_id = p_demand_source_line_id
1530: AND nvl(project_id, -99) = nvl(p_project_id, -99)
1531: AND nvl(task_id, -99) = nvl(p_task_id, -99)
1532: AND NOT EXISTS (SELECT 1 FROM MTL_RESERVATIONS MR
1533: WHERE MR.demand_source_line_id = p_demand_source_line_id
1534: AND MR.demand_source_type_id = p_demand_source_type_id
1535: AND MR.demand_source_header_id = p_demand_source_header_id
1536: AND NVL (MR.staged_flag,'N') <> 'Y' ) ;

Line 1613: SELECT 1 FROM mtl_reservations mr

1609: WHERE wdd.source_line_id = p_demand_source_line_id
1610: AND wdd.released_status IN ('Y','C')
1611: AND NOT EXISTS
1612: (
1613: SELECT 1 FROM mtl_reservations mr
1614: WHERE mr.demand_source_line_id = wdd.source_line_id
1615: AND nvl(mr.staged_flag, 'N') = 'Y'
1616: AND mr.inventory_item_id = wdd.inventory_item_id
1617: AND mr.organization_id = wdd.organization_id