194: INTO l_src_org_lot_ctrl
195: , l_src_org_srl_ctrl
196: , l_rcv_org_lot_ctrl
197: , l_source_document_code
198: FROM mtl_system_items msi1
199: , mtl_system_items msi2
200: , rcv_shipment_lines rsl
201: WHERE rsl.shipment_header_id = p_shipment_header_id
202: AND rsl.to_organization_id = p_organization_id
195: , l_src_org_srl_ctrl
196: , l_rcv_org_lot_ctrl
197: , l_source_document_code
198: FROM mtl_system_items msi1
199: , mtl_system_items msi2
200: , rcv_shipment_lines rsl
201: WHERE rsl.shipment_header_id = p_shipment_header_id
202: AND rsl.to_organization_id = p_organization_id
203: AND rsl.item_id = p_item_id
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
1894: l_serial_number_control_code NUMBER;
1895: BEGIN
1896: SELECT serial_number_control_code
1897: INTO l_serial_number_control_code
1898: FROM mtl_system_items_b
1899: WHERE organization_id = p_organization_id
1900: AND inventory_item_id = p_inventory_item_id;
1901:
1902: IF l_serial_number_control_code = 6 THEN
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
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
2787: , msn.current_locator_id
2804: , inv_project.get_project_number
2805: , inv_project.get_task_id
2806: , inv_project.get_task_number
2807: FROM mtl_serial_numbers msn
2808: , mtl_system_items_vl msiv
2809: , mtl_item_locations_kfv milv
2810: , mtl_secondary_inventories msi
2811: WHERE msn.current_organization_id = p_current_organization_id
2812: AND msn.lpn_id IS NULL