APPS.INV_LPN_RESERVATIONS_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 819: FROM wms_license_plate_numbers

815: locator_id = p_to_locator_id
816: WHERE organization_id = p_organization_id
817: AND inventory_item_id = p_inventory_item_id
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,

Line 827: FROM wms_license_plate_numbers

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
827: FROM wms_license_plate_numbers
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

Line 839: FROM wms_license_plate_numbers

835: lpn_id = NULL
836: WHERE organization_id = p_organization_id
837: AND inventory_item_id = p_inventory_item_id
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,

Line 848: FROM wms_license_plate_numbers

844: locator_id = p_to_locator_id,
845: lpn_id = NULL
846: WHERE organization_id = p_organization_id
847: AND lpn_id IN (SELECT lpn_id
848: FROM wms_license_plate_numbers
849: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id); --NESTED LPN ER 7307189
850: END IF;
851: END IF;
852: ELSE --Bug 6007873

Line 860: FROM wms_license_plate_numbers

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
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

Line 866: FROM wms_license_plate_numbers

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
868: END IF;
869: END IF;
870:

Line 987: FROM wms_license_plate_numbers

983: , lpn_id=p_transfer_lpn_id
984: WHERE organization_id = p_organization_id
985: AND inventory_item_id = p_inventory_item_id
986: AND lpn_id IN (SELECT lpn_id
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

Line 997: FROM wms_license_plate_numbers

993: , locator_id = p_to_locator_id
994: , lpn_id=p_transfer_lpn_id
995: WHERE organization_id = p_organization_id
996: AND lpn_id IN (SELECT lpn_id
997: FROM wms_license_plate_numbers
998: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ) --nested lpn
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.

Line 1010: FROM wms_license_plate_numbers

1006: , lpn_id=NULL
1007: WHERE organization_id = p_organization_id
1008: AND inventory_item_id = p_inventory_item_id
1009: AND lpn_id IN (SELECT lpn_id
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

Line 1020: FROM wms_license_plate_numbers

1016: , locator_id = p_to_locator_id
1017: , lpn_id=NULL
1018: WHERE organization_id = p_organization_id
1019: AND lpn_id IN (SELECT lpn_id
1020: FROM wms_license_plate_numbers
1021: WHERE outermost_lpn_id = p_lpn_id OR lpn_id = p_lpn_id ) --nested lpn
1022: AND demand_source_line_detail IS NULL;
1023: END IF;
1024: END IF;

Line 1033: FROM wms_license_plate_numbers

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
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

Line 1039: FROM wms_license_plate_numbers

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
1041: END IF;
1042: END IF;
1043: