DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1568: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1564: , nvl(msn.attribute12, msnt.attribute12) attribute12
1565: , nvl(msn.attribute13, msnt.attribute13) attribute13
1566: , nvl(msn.attribute14, msnt.attribute14) attribute14
1567: , nvl(msn.attribute15, msnt.attribute15) attribute15
1568: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1569: WHERE msn.inventory_item_id = p_inventory_item_id
1570: AND msn.serial_number = p_serial_number
1571: AND msnt.transaction_temp_id = p_transaction_temp_id
1572: AND msnt.fm_serial_number = p_serial_number

Line 1592: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1588: ,msnt.attribute12 attribute12
1589: ,msnt.attribute13 attribute13
1590: ,msnt.attribute14 attribute14
1591: ,msnt.attribute15 attribute15
1592: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1593: WHERE msn.inventory_item_id = p_inventory_item_id
1594: AND msn.serial_number = p_serial_number
1595: AND msnt.transaction_temp_id = p_transaction_temp_id
1596: AND msnt.fm_serial_number = p_serial_number