[Home] [Help]
1043: , msn.lpn_id
1044: , wlpn.license_plate_number
1045: , msn.current_status
1046: , msik.primary_uom_code
1047: FROM mtl_serial_numbers msn, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1048: WHERE (msn.group_mark_id IS NULL
1049: OR msn.group_mark_id = -1
1050: )
1051: AND ((msn.current_organization_id = p_organization_id
1084: , msn.lpn_id
1085: , wlpn.license_plate_number
1086: , msn.current_status
1087: , msik.primary_uom_code
1088: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1089: WHERE (msn.group_mark_id IS NULL
1090: OR msn.group_mark_id = -1
1091: )
1092: AND msn.current_organization_id = p_organization_id
1620: , msn.lpn_id
1621: , wlpn.license_plate_number
1622: , msn.current_status
1623: , msik.primary_uom_code
1624: FROM mtl_serial_numbers msn, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1625: WHERE (msn.group_mark_id IS NULL
1626: OR msn.group_mark_id = -1
1627: )
1628: AND ((msn.current_organization_id = p_organization_id
1691: , wlpn.license_plate_number
1692: , msn.current_status
1693: , msik.primary_uom_code
1694: FROM mtl_serial_numbers msn, mtl_cycle_count_entries mcce,
1695: mtl_system_items_kfv msik, wms_license_plate_numbers wlpn
1696: WHERE (msn.group_mark_id IS NULL
1697: OR msn.group_mark_id = -1
1698: )
1699: AND msn.current_organization_id = p_organization_id
2778: -- LOV query for serial triggered subinventory transfer
2779: 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
2780: BEGIN
2781: -- For serial triggered subinventory transfer
2782: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
2783: 'MTL_SYSTEM_ITEMS_VL'.*/
2784: OPEN x_serials FOR
2785: SELECT DISTINCT msn.serial_number
2786: , msn.current_subinventory_code