DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1720: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1716: , nvl(msn.attribute12, msnt.attribute12) attribute12
1717: , nvl(msn.attribute13, msnt.attribute13) attribute13
1718: , nvl(msn.attribute14, msnt.attribute14) attribute14
1719: , nvl(msn.attribute15, msnt.attribute15) attribute15
1720: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1721: WHERE msn.inventory_item_id = p_inventory_item_id
1722: AND msn.serial_number = p_serial_number
1723: AND msnt.transaction_temp_id = p_transaction_temp_id
1724: AND msnt.fm_serial_number = p_serial_number

Line 1744: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1740: ,msnt.attribute12 attribute12
1741: ,msnt.attribute13 attribute13
1742: ,msnt.attribute14 attribute14
1743: ,msnt.attribute15 attribute15
1744: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1745: WHERE msn.inventory_item_id = p_inventory_item_id
1746: AND msn.serial_number = p_serial_number
1747: AND msnt.transaction_temp_id = p_transaction_temp_id
1748: AND msnt.fm_serial_number = p_serial_number