[Home] [Help]
179: INTO l_src_org_lot_ctrl
180: , l_src_org_srl_ctrl
181: , l_rcv_org_lot_ctrl
182: , l_source_document_code
183: FROM mtl_system_items msi1
184: , mtl_system_items msi2
185: , rcv_shipment_lines rsl
186: WHERE rsl.shipment_header_id = p_shipment_header_id
187: AND rsl.to_organization_id = p_organization_id
180: , l_src_org_srl_ctrl
181: , l_rcv_org_lot_ctrl
182: , l_source_document_code
183: FROM mtl_system_items msi1
184: , mtl_system_items msi2
185: , rcv_shipment_lines rsl
186: WHERE rsl.shipment_header_id = p_shipment_header_id
187: AND rsl.to_organization_id = p_organization_id
188: AND rsl.item_id = p_item_id
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
1831: l_serial_number_control_code NUMBER;
1832: BEGIN
1833: SELECT serial_number_control_code
1834: INTO l_serial_number_control_code
1835: FROM mtl_system_items_b
1836: WHERE organization_id = p_organization_id
1837: AND inventory_item_id = p_inventory_item_id;
1838:
1839: IF l_serial_number_control_code = 6 THEN
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
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
2700: , msn.current_locator_id
2717: , inv_project.get_project_number
2718: , inv_project.get_task_id
2719: , inv_project.get_task_number
2720: FROM mtl_serial_numbers msn
2721: , mtl_system_items_vl msiv
2722: , mtl_item_locations_kfv milv
2723: , mtl_secondary_inventories msi
2724: WHERE msn.current_organization_id = p_current_organization_id
2725: AND msn.lpn_id IS NULL