APPS.INV_ITEM_INQ dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1459: mtl_serial_numbers_temp msnt,

1455: /* PACKING CONTEXT */
1456: OPEN x_serial_attributes FOR
1457: SELECT mmst.status_code, msik.serial_status_enabled, mmst.status_id
1458: FROM mtl_material_statuses_vl mmst,
1459: mtl_serial_numbers_temp msnt,
1460: mtl_material_transactions_temp mmtt,
1461: mtl_transaction_lots_temp mtlt,
1462: mtl_system_items_b msik
1463: WHERE mmtt.organization_id = p_organization_id

Line 1688: FROM mtl_serial_numbers_temp msnt,

1684: THEN
1685: /* PACKING CONTEXT */
1686: OPEN x_serial_numbers FOR
1687: SELECT msnt.fm_serial_number, mmtt.transfer_lpn_id, mtlt.lot_number
1688: FROM mtl_serial_numbers_temp msnt,
1689: mtl_material_transactions_temp mmtt,
1690: mtl_transaction_lots_temp mtlt
1691: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1692: and nvl(mtlt.serial_transaction_temp_id,mmtt.transaction_temp_id) = msnt.transaction_temp_id