APPS.INV_UI_ITEM_ATT_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

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

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

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

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

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

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

Line 1695: mtl_system_items_kfv msik, wms_license_plate_numbers wlpn

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