APPS.INV_UI_ITEM_ATT_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 984: FROM mtl_serial_numbers msn, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn

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

Line 1025: FROM mtl_serial_numbers msn, mtl_physical_inventory_tags mpit, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn

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

Line 1561: FROM mtl_serial_numbers msn, mtl_system_items_kfv msik, wms_license_plate_numbers wlpn

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

Line 1632: mtl_system_items_kfv msik, wms_license_plate_numbers wlpn

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