APPS.INV_UI_ITEM_LOVS dependencies on MTL_SERIAL_NUMBERS

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

5410: NVL(msi.SECONDARY_DEFAULT_IND,''),
5411: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5412: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5413: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5414: FROM mtl_serial_numbers msn, mtl_system_items_vl msi /* Bug 5581528 */
5415: WHERE msn.current_organization_id = p_org_id
5416: AND msn.serial_number = p_serial
5417: AND msn.inventory_item_id = msi.inventory_item_id
5418: AND msi.organization_id = msn.current_organization_id

Line 5468: FROM mtl_serial_numbers msn,

5464: NVL(msi.SECONDARY_DEFAULT_IND,''),
5465: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5466: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5467: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5468: FROM mtl_serial_numbers msn,
5469: mtl_system_items_vl msi, /* Bug 5581528 */
5470: mtl_cross_references mcr
5471: WHERE msn.current_organization_id = p_org_id
5472: AND msn.serial_number = p_serial

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

5587: NVL(msi.SECONDARY_DEFAULT_IND,''),
5588: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5589: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5590: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5591: FROM mtl_system_items_vl msi, mtl_serial_numbers msn /* Bug 5581528 */
5592: WHERE msn.lpn_id = p_lpn_id
5593: AND msn.last_txn_source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5594: AND msn.current_organization_id = p_org_id
5595: AND msi.organization_id = msn.current_organization_id

Line 5706: mtl_serial_numbers msn,

5702: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5703: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5704: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5705: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5706: mtl_serial_numbers msn,
5707: mtl_cross_references mcr
5708: WHERE msn.lpn_id = p_lpn_id
5709: AND msn.last_txn_source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5710: AND msn.current_organization_id = p_org_id