[Home] [Help]
980: , msn.lpn_id
981: , wlpn.license_plate_number
982: , msn.current_status
983: , msik.primary_uom_code
984: FROM mtl_serial_numbers msn, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
985: WHERE (msn.group_mark_id IS NULL
986: OR msn.group_mark_id = -1
987: )
988: AND ((msn.current_organization_id = p_organization_id
1021: , msn.lpn_id
1022: , wlpn.license_plate_number
1023: , msn.current_status
1024: , msik.primary_uom_code
1025: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1026: WHERE (msn.group_mark_id IS NULL
1027: OR msn.group_mark_id = -1
1028: )
1029: AND msn.current_organization_id = p_organization_id
1557: , msn.lpn_id
1558: , wlpn.license_plate_number
1559: , msn.current_status
1560: , msik.primary_uom_code
1561: FROM mtl_serial_numbers msn, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1562: WHERE (msn.group_mark_id IS NULL
1563: OR msn.group_mark_id = -1
1564: )
1565: AND ((msn.current_organization_id = p_organization_id
1628: , wlpn.license_plate_number
1629: , msn.current_status
1630: , msik.primary_uom_code
1631: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce,
1632: mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1633: WHERE (msn.group_mark_id IS NULL
1634: OR msn.group_mark_id = -1
1635: )
1636: AND msn.current_organization_id = p_organization_id
2691: -- LOV query for serial triggered subinventory transfer
2692: PROCEDURE get_serial_subxfr_lov(x_serials OUT NOCOPY t_genref, p_current_organization_id IN NUMBER, p_serial_number IN VARCHAR2, p_transaction_type_id IN NUMBER, p_wms_installed IN VARCHAR2) IS
2693: BEGIN
2694: -- For serial triggered subinventory transfer
2695: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
2696: 'MTL_SYSTEM_ITEMS_VL'.*/
2697: OPEN x_serials FOR
2698: SELECT DISTINCT msn.serial_number
2699: , msn.current_subinventory_code