APPS.INV_TXN_VALIDATIONS dependencies on MTL_SERIAL_NUMBERS

Line 114: FROM MTL_SERIAL_NUMBERS

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

Line 144: FROM mtl_serial_numbers

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

Line 1908: from mtl_serial_numbers

1904: and organization_id = p_org_id;
1905:
1906: CURSOR c_lpn_serial(p_lpnid NUMBER) IS
1907: select serial_number, inventory_item_id
1908: from mtl_serial_numbers
1909: where lpn_id = p_lpnid
1910: and current_organization_id = p_org_id;
1911:
1912: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1927: from mtl_serial_numbers_temp msnt,

1923:
1924: begin
1925: select 1
1926: into l_cnt
1927: from mtl_serial_numbers_temp msnt,
1928: mtl_transaction_lots_temp mtlt,
1929: mtl_material_transactions_temp mmtt
1930: where mmtt.organization_id = p_org_id
1931: and mmtt.inventory_item_id = l_inventory_item_id

Line 1985: from mtl_serial_numbers_temp msnt,

1981: BEGIN
1982:
1983: select 1
1984: into l_cnt
1985: from mtl_serial_numbers_temp msnt,
1986: mtl_transaction_lots_temp mtlt,
1987: mtl_material_transactions_temp mmtt
1988: where mmtt.organization_id = p_org_id
1989: and mmtt.inventory_item_id = p_item_id

Line 3322: from mtl_serial_numbers_temp

3318: if p_lot is null then
3319: begin
3320: select 1
3321: into l_serial_exist
3322: from mtl_serial_numbers_temp
3323: where transaction_temp_id = l_transaction_temp_id
3324: and p_serial between fm_serial_number and nvl(to_serial_number, fm_serial_number);
3325: exception
3326: when others then

Line 3334: mtl_serial_numbers_temp msnt

3330: begin
3331: select 1
3332: into l_serial_exist
3333: from mtl_transaction_lots_temp mtlt,
3334: mtl_serial_numbers_temp msnt
3335: where mtlt.transaction_temp_id = l_transaction_temp_id
3336: and mtlt.lot_number = p_lot
3337: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
3338: and p_serial between msnt.fm_serial_number and nvl(msnt.to_serial_number, msnt.fm_serial_number);

Line 3821: l_group_mark_id FROM mtl_serial_numbers WHERE

3817:
3818: /** R12 Enhanced reservations project **/
3819: BEGIN
3820: SELECT reservation_id, group_mark_id INTO l_reservation_id,
3821: l_group_mark_id FROM mtl_serial_numbers WHERE
3822: serial_number = p_serial_number AND inventory_item_id = p_inventory_item_id;
3823: EXCEPTION
3824: WHEN no_data_found THEN
3825: IF (l_debug = 1) THEN

Line 3919: update mtl_serial_numbers

3915: /** R12 Enhanced reservation project **/
3916: -- update only if is not reserved. Otherwise it would have been
3917: -- marked already
3918: IF l_group_mark_id IS NULL OR l_group_mark_id < 0 then
3919: update mtl_serial_numbers
3920: set group_mark_id = 1
3921: where inventory_item_id = p_inventory_item_id
3922: and serial_number = p_serial_number;
3923: END IF;