APPS.INV_UI_ITEM_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 5764: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn

5760: SELECT DISTINCT muom.uom_code
5761: , muom.unit_of_measure
5762: , muom.description
5763: , muom.uom_class
5764: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn
5765: WHERE muom.uom_code LIKE (p_uom_text)
5766: AND wlpn.lpn_id = p_lpn_id
5767: AND muom.uom_code = wlpn.gross_weight_uom_code
5768: UNION

Line 6068: 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'

6064: l_sql_stmt_xref := l_sql_stmt_xref || ' AND moqd.locator_id = ' || p_locator_id;
6065: END IF;
6066: END IF;
6067: ELSE
6068: 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'
6069: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
6070: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
6071: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
6072: || ' AND msik.concatenated_segments LIKE (''' || p_concatenated_segments ||l_append|| ''')' -- Bug 9369327

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

6075: || ' AND moqd.organization_id = msik.organization_id'
6076: || ' AND moqd.inventory_item_id = msik.inventory_item_id';
6077:
6078: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
6079: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
6080: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
6081: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
6082: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
6083: || ' AND msik.organization_id = ' || p_organization_id