APPS.INV_UI_ITEM_LOVS dependencies on MTL_SERIAL_NUMBERS

Line 5122: FROM mtl_serial_numbers msn, mtl_system_items_vl msi /* Bug 5581528 */

5118: NVL(msi.SECONDARY_DEFAULT_IND,''),
5119: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5120: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5121: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5122: FROM mtl_serial_numbers msn, mtl_system_items_vl msi /* Bug 5581528 */
5123: WHERE msn.current_organization_id = p_org_id
5124: AND msn.serial_number = p_serial
5125: AND msn.inventory_item_id = msi.inventory_item_id
5126: AND msi.organization_id = msn.current_organization_id

Line 5175: FROM mtl_serial_numbers msn,

5171: NVL(msi.SECONDARY_DEFAULT_IND,''),
5172: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5173: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5174: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5175: FROM mtl_serial_numbers msn,
5176: mtl_system_items_vl msi, /* Bug 5581528 */
5177: mtl_cross_references mcr
5178: WHERE msn.current_organization_id = p_org_id
5179: AND msn.serial_number = p_serial

Line 5292: FROM mtl_system_items_vl msi, mtl_serial_numbers msn /* Bug 5581528 */

5288: NVL(msi.SECONDARY_DEFAULT_IND,''),
5289: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5290: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5291: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5292: FROM mtl_system_items_vl msi, mtl_serial_numbers msn /* Bug 5581528 */
5293: WHERE msn.lpn_id = p_lpn_id
5294: AND msn.last_txn_source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5295: AND msn.current_organization_id = p_org_id
5296: AND msi.organization_id = msn.current_organization_id

Line 5405: mtl_serial_numbers msn,

5401: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5402: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5403: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5404: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5405: mtl_serial_numbers msn,
5406: mtl_cross_references mcr
5407: WHERE msn.lpn_id = p_lpn_id
5408: AND msn.last_txn_source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5409: AND msn.current_organization_id = p_org_id