APPS.INV_TXN_VALIDATIONS dependencies on MTL_SERIAL_NUMBERS

Line 111: FROM MTL_SERIAL_NUMBERS

107: current_subinventory_code,
108: revision,
109: lot_number
110: INTO l_SN_Info
111: FROM MTL_SERIAL_NUMBERS
112: WHERE inventory_item_id = p_Inventory_Item_Id and
113: current_organization_id = p_Current_Organization_Id and
114: serial_number = p_Serial_Number;
115:

Line 141: FROM mtl_serial_numbers

137:
138: END IF;
139:
140: SELECT current_status INTO l_curr_stat
141: FROM mtl_serial_numbers
142: WHERE inventory_item_id = p_Inventory_Item_Id AND
143: current_organization_id = p_Current_Organization_Id AND
144: serial_number = p_Serial_Number;
145:

Line 2061: from mtl_serial_numbers

2057: and organization_id = p_org_id;
2058:
2059: CURSOR c_lpn_serial(p_lpnid NUMBER) IS
2060: select serial_number, inventory_item_id
2061: from mtl_serial_numbers
2062: where lpn_id = p_lpnid
2063: and current_organization_id = p_org_id;
2064:
2065: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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);

Line 4100: l_group_mark_id FROM mtl_serial_numbers WHERE

4096:
4097: /** R12 Enhanced reservations project **/
4098: BEGIN
4099: SELECT reservation_id, group_mark_id INTO l_reservation_id,
4100: l_group_mark_id FROM mtl_serial_numbers WHERE
4101: serial_number = p_serial_number AND inventory_item_id = p_inventory_item_id;
4102: EXCEPTION
4103: WHEN no_data_found THEN
4104: IF (l_debug = 1) THEN

Line 4198: update mtl_serial_numbers

4194: /** R12 Enhanced reservation project **/
4195: -- update only if is not reserved. Otherwise it would have been
4196: -- marked already
4197: IF l_group_mark_id IS NULL OR l_group_mark_id < 0 then
4198: update mtl_serial_numbers
4199: set group_mark_id = 1
4200: where inventory_item_id = p_inventory_item_id
4201: and serial_number = p_serial_number;
4202: END IF;