APPS.INV_TXN_VALIDATIONS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2080: from mtl_serial_numbers_temp msnt,

2076:
2077: begin
2078: select 1
2079: into l_cnt
2080: from mtl_serial_numbers_temp msnt,
2081: mtl_transaction_lots_temp mtlt,
2082: mtl_material_transactions_temp mmtt
2083: where mmtt.organization_id = p_org_id
2084: and mmtt.inventory_item_id = l_inventory_item_id

Line 2211: from mtl_serial_numbers_temp msnt,

2207: BEGIN
2208:
2209: select 1
2210: into l_cnt
2211: from mtl_serial_numbers_temp msnt,
2212: mtl_transaction_lots_temp mtlt,
2213: mtl_material_transactions_temp mmtt
2214: where mmtt.organization_id = p_org_id
2215: and mmtt.inventory_item_id = p_item_id

Line 3601: from mtl_serial_numbers_temp

3597: if p_lot is null then
3598: begin
3599: select 1
3600: into l_serial_exist
3601: from mtl_serial_numbers_temp
3602: where transaction_temp_id = l_transaction_temp_id
3603: and p_serial between fm_serial_number and nvl(to_serial_number, fm_serial_number);
3604: exception
3605: when others then

Line 3613: mtl_serial_numbers_temp msnt

3609: begin
3610: select 1
3611: into l_serial_exist
3612: from mtl_transaction_lots_temp mtlt,
3613: mtl_serial_numbers_temp msnt
3614: where mtlt.transaction_temp_id = l_transaction_temp_id
3615: and mtlt.lot_number = p_lot
3616: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
3617: and p_serial between msnt.fm_serial_number and nvl(msnt.to_serial_number, msnt.fm_serial_number);