APPS.INV_UI_ITEM_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 5463: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn

5459: SELECT DISTINCT muom.uom_code
5460: , muom.unit_of_measure
5461: , muom.description
5462: , muom.uom_class
5463: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn
5464: WHERE muom.uom_code LIKE (p_uom_text)
5465: AND wlpn.lpn_id = p_lpn_id
5466: AND muom.uom_code = wlpn.gross_weight_uom_code
5467: UNION

Line 5734: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'

5730: l_sql_stmt_xref := l_sql_stmt_xref || ' AND moqd.locator_id = ' || p_locator_id;
5731: END IF;
5732: END IF;
5733: ELSE
5734: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
5735: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
5736: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
5737: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
5738: || ' AND msik.concatenated_segments LIKE (''' || p_concatenated_segments || ''')'

Line 5745: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'

5741: || ' AND moqd.organization_id = msik.organization_id'
5742: || ' AND moqd.inventory_item_id = msik.inventory_item_id';
5743:
5744: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
5745: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
5746: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
5747: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
5748: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
5749: || ' AND msik.organization_id = ' || p_organization_id