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.

[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on MTL_RESERVATIONS

Line 303: FROM mtl_reservations

299: IF (l_wip_entity_type = inv_reservation_global.g_wip_source_type_fpo OR
300: l_wip_entity_type = inv_reservation_global.g_wip_source_type_batch) THEN
301: SELECT nvl(sum(primary_reservation_quantity), 0)
302: INTO l_primary_reserved_quantity
303: FROM mtl_reservations
304: WHERE supply_source_type_id = p_supply_source_type_id
305: AND supply_source_header_id = p_supply_source_header_id
306: AND supply_source_line_id = p_supply_source_line_id;
307: ELSE

Line 310: FROM mtl_reservations

306: AND supply_source_line_id = p_supply_source_line_id;
307: ELSE
308: SELECT nvl(sum(primary_reservation_quantity), 0)
309: INTO l_primary_reserved_quantity
310: FROM mtl_reservations
311: WHERE supply_source_type_id = p_supply_source_type_id
312: AND supply_source_header_id = p_supply_source_header_id;
313: END IF;
314: -- BUG 5052424 END

Line 437: FROM mtl_reservations

433: -- get the sum of quantity that is already reserved on the document.
434: BEGIN
435: SELECT nvl(sum(primary_reservation_quantity), 0)
436: INTO l_primary_reserved_quantity
437: FROM mtl_reservations
438: WHERE supply_source_type_id = p_supply_source_type_id
439: AND supply_source_header_id = p_supply_source_header_id
440: AND supply_source_line_id = p_supply_source_line_id
441: AND nvl(project_id, -99) = nvl(p_project_id, -99)

Line 459: FROM mtl_reservations

455: -- get the sum of quantity that is already reserved on the document.
456: BEGIN
457: SELECT nvl(sum(primary_reservation_quantity), 0)
458: INTO l_primary_reserved_quantity
459: FROM mtl_reservations
460: WHERE supply_source_type_id = p_supply_source_type_id
461: AND supply_source_header_id = p_supply_source_header_id
462: AND supply_source_line_id = p_supply_source_line_id
463: AND supply_source_line_detail = p_supply_source_line_detail

Line 564: FROM mtl_reservations

560: -- get the sum of quantity that is already reserved on the document.
561: BEGIN
562: SELECT nvl(sum(primary_reservation_quantity), 0)
563: INTO l_primary_reserved_quantity
564: FROM mtl_reservations
565: WHERE supply_source_type_id = p_supply_source_type_id
566: AND organization_id = p_organization_id
567: AND inventory_item_id = p_item_id;
568: EXCEPTION

Line 771: FROM mtl_reservations

767: -- for cmro demand.
768: BEGIN
769: SELECT nvl(sum(primary_reservation_quantity), 0)
770: INTO l_primary_reserved_quantity
771: FROM mtl_reservations
772: WHERE demand_source_type_id = p_demand_source_type_id
773: AND demand_source_header_id = p_demand_source_header_id
774: AND demand_source_line_id = p_demand_source_line_id
775: AND demand_source_line_detail = p_demand_source_line_detail;

Line 834: FROM mtl_reservations

830: -- get the sum of quantity that is already reserved on the document.
831: BEGIN
832: SELECT nvl(sum(primary_reservation_quantity), 0)
833: INTO l_primary_reserved_quantity
834: FROM mtl_reservations
835: WHERE demand_source_type_id = p_demand_source_type_id
836: AND demand_source_header_id = p_demand_source_header_id
837: AND demand_source_line_id = p_demand_source_line_id;
838: EXCEPTION

Line 917: FROM mtl_reservations

913: -- get reservation quantity against the wdd with line detail level
914: BEGIN
915: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
916: INTO l_wdd_primary_reserved_qty, l_rsv_primary_uom_code
917: FROM mtl_reservations
918: WHERE demand_source_type_id = p_demand_source_type_id
919: AND demand_source_header_id = p_demand_source_header_id
920: AND demand_source_line_id = p_demand_source_line_id
921: AND demand_source_line_detail = p_demand_source_line_detail

Line 944: FROM mtl_reservations

940: -- get all reservation quantity at the order line level
941: BEGIN
942: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
943: INTO l_primary_reserved_quantity, l_rsv_primary_uom_code
944: FROM mtl_reservations
945: WHERE demand_source_type_id = p_demand_source_type_id
946: AND demand_source_header_id = p_demand_source_header_id
947: AND demand_source_line_id = p_demand_source_line_id
948: GROUP BY primary_uom_code;

Line 975: FROM mtl_reservations

971: -- get all reservation quantity at the order line level
972: BEGIN
973: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
974: INTO l_primary_reserved_quantity, l_rsv_primary_uom_code
975: FROM mtl_reservations
976: WHERE demand_source_type_id = p_demand_source_type_id
977: AND demand_source_header_id = p_demand_source_header_id
978: AND demand_source_line_id = p_demand_source_line_id
979: GROUP BY primary_uom_code;

Line 1005: FROM mtl_reservations

1001: -- get all reservation quantity with the line detail = null
1002: BEGIN
1003: SELECT nvl(sum(primary_reservation_quantity), 0), primary_uom_code
1004: INTO l_primary_reserved_quantity, l_rsv_primary_uom_code
1005: FROM mtl_reservations
1006: WHERE demand_source_type_id = p_demand_source_type_id
1007: AND demand_source_header_id = p_demand_source_header_id
1008: AND demand_source_line_id = p_demand_source_line_id
1009: AND demand_source_line_detail is null