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_LPN_RESERVATIONS_PVT dependencies on MTL_RESERVATIONS

Line 48: FROM mtl_reservations

44: INTO l_result
45: FROM dual
46: WHERE EXISTS (
47: SELECT 1
48: FROM mtl_reservations
49: WHERE organization_id = p_org_id
50: AND inventory_item_id = p_item_id
51: AND (demand_source_line_id <> p_demand_source_line_id
52: OR demand_source_line_id IS NULL)

Line 61: FROM mtl_reservations

57: INTO l_result
58: FROM dual
59: WHERE EXISTS (
60: SELECT 1
61: FROM mtl_reservations
62: WHERE organization_id = p_org_id
63: AND inventory_item_id = p_item_id
64: AND (demand_source_header_id <> p_demand_source_header_id
65: OR demand_source_header_id IS NULL)

Line 74: FROM mtl_reservations

70: INTO l_result
71: FROM dual
72: WHERE EXISTS (
73: SELECT 1
74: FROM mtl_reservations
75: WHERE organization_id = p_org_id
76: AND inventory_item_id = p_item_id
77: AND (demand_source_name <> p_demand_source_name
78: OR demand_source_name IS NULL)

Line 278: FROM mtl_reservations

274: -- peg the remaining order qty to the remaining LPN qty }}
275: --
276: SELECT nvl(sum(primary_reservation_quantity),0)
277: INTO l_reserved_qty
278: FROM mtl_reservations
279: WHERE demand_source_line_id = p_demand_source_line_id
280: AND organization_id = p_organization_id
281: AND inventory_item_id = p_inventory_item_id;
282:

Line 285: FROM mtl_reservations

281: AND inventory_item_id = p_inventory_item_id;
282:
283: SELECT nvl(sum(primary_reservation_quantity),0)
284: INTO l_lpn_reserved_qty
285: FROM mtl_reservations
286: WHERE demand_source_line_id = p_demand_source_line_id
287: AND lpn_id = p_lpn_id
288: AND organization_id = p_organization_id
289: AND inventory_item_id = p_inventory_item_id

Line 813: UPDATE mtl_reservations

809: ----Bug 6007873 Added if
810: IF l_reservable_type = 1 THEN --transfer Sub is reservable, keep the reservation record
811: IF l_lpn_controlled_flag = 1 THEN --transfer Sub is LPN controlled, keep the lpn_id stamping
812: IF p_inventory_item_id IS NOT NULL THEN
813: UPDATE mtl_reservations
814: SET subinventory_code = p_to_subinventory_code,
815: locator_id = p_to_locator_id
816: WHERE organization_id = p_organization_id
817: AND inventory_item_id = p_inventory_item_id

Line 822: UPDATE mtl_reservations

818: AND lpn_id IN (SELECT lpn_id
819: FROM wms_license_plate_numbers
820: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id); --NESTED LPN ER 7307189
821: ELSE
822: UPDATE mtl_reservations
823: SET subinventory_code = p_to_subinventory_code,
824: locator_id = p_to_locator_id
825: WHERE organization_id = p_organization_id
826: AND lpn_id IN (SELECT lpn_id

Line 832: UPDATE mtl_reservations

828: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id); --NESTED LPN ER 7307189
829: END IF;
830: ELSE --transfer Sub is Non-LPN controlled, null out the lpn_id stamping as LPN will be unpacked.
831: IF p_inventory_item_id IS NOT NULL THEN
832: UPDATE mtl_reservations
833: SET subinventory_code = p_to_subinventory_code,
834: locator_id = p_to_locator_id,
835: lpn_id = NULL
836: WHERE organization_id = p_organization_id

Line 842: UPDATE mtl_reservations

838: AND lpn_id IN (SELECT lpn_id
839: FROM wms_license_plate_numbers
840: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id); --NESTED LPN ER 7307189
841: ELSE
842: UPDATE mtl_reservations
843: SET subinventory_code = p_to_subinventory_code,
844: locator_id = p_to_locator_id,
845: lpn_id = NULL
846: WHERE organization_id = p_organization_id

Line 856: DELETE FROM mtl_reservations

852: ELSE --Bug 6007873
853: -- sub is non-reservable
854: --need to delete the reservations
855: IF p_inventory_item_id IS NOT NULL THEN
856: DELETE FROM mtl_reservations
857: WHERE organization_id = p_organization_id
858: AND inventory_item_id = p_inventory_item_id
859: AND lpn_id IN (SELECT lpn_id
860: FROM wms_license_plate_numbers

Line 863: DELETE FROM mtl_reservations

859: AND lpn_id IN (SELECT lpn_id
860: FROM wms_license_plate_numbers
861: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id); --NESTED LPN ER 7307189
862: ELSE
863: DELETE FROM mtl_reservations
864: WHERE organization_id = p_organization_id
865: AND lpn_id IN (SELECT lpn_id
866: FROM wms_license_plate_numbers
867: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ); --NESTED LPN ER 7307189

Line 980: UPDATE mtl_reservations

976:
977: IF l_reservable_type = 1 THEN --transfer Sub is reservable, keep the reservation record
978: IF l_lpn_controlled_flag = 1 THEN --transfer Sub is LPN controlled, keep the lpn_id stamping
979: IF p_inventory_item_id IS NOT NULL THEN
980: UPDATE mtl_reservations
981: SET subinventory_code = p_to_subinventory_code
982: , locator_id = p_to_locator_id
983: , lpn_id=p_transfer_lpn_id
984: WHERE organization_id = p_organization_id

Line 991: UPDATE mtl_reservations

987: FROM wms_license_plate_numbers
988: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ) --nested lpn
989: AND demand_source_line_detail IS NULL;
990: ELSE
991: UPDATE mtl_reservations
992: SET subinventory_code = p_to_subinventory_code
993: , locator_id = p_to_locator_id
994: , lpn_id=p_transfer_lpn_id
995: WHERE organization_id = p_organization_id

Line 1003: UPDATE mtl_reservations

999: AND demand_source_line_detail IS NULL;
1000: END IF;
1001: ELSE --transfer Sub is Non-LPN controlled, null out the lpn_id stamping as LPN will be unpacked.
1002: IF p_inventory_item_id IS NOT NULL THEN
1003: UPDATE mtl_reservations
1004: SET subinventory_code = p_to_subinventory_code
1005: , locator_id = p_to_locator_id
1006: , lpn_id=NULL
1007: WHERE organization_id = p_organization_id

Line 1014: UPDATE mtl_reservations

1010: FROM wms_license_plate_numbers
1011: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ) --nested lpn
1012: AND demand_source_line_detail IS NULL;
1013: ELSE
1014: UPDATE mtl_reservations
1015: SET subinventory_code = p_to_subinventory_code
1016: , locator_id = p_to_locator_id
1017: , lpn_id=NULL
1018: WHERE organization_id = p_organization_id

Line 1029: DELETE FROM mtl_reservations

1025: ELSE
1026: -- sub is non-reservable
1027: --need to delete the reservations
1028: IF p_inventory_item_id IS NOT NULL THEN
1029: DELETE FROM mtl_reservations
1030: WHERE organization_id = p_organization_id
1031: AND inventory_item_id = p_inventory_item_id
1032: AND lpn_id IN (SELECT lpn_id
1033: FROM wms_license_plate_numbers

Line 1036: DELETE FROM mtl_reservations

1032: AND lpn_id IN (SELECT lpn_id
1033: FROM wms_license_plate_numbers
1034: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ); --nested lpn
1035: ELSE
1036: DELETE FROM mtl_reservations
1037: WHERE organization_id = p_organization_id
1038: AND lpn_id IN (SELECT lpn_id
1039: FROM wms_license_plate_numbers
1040: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ); --nested lpn