APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS

Line 2316: FROM mtl_serial_numbers_interface

2312: BEGIN
2313: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2314: SELECT count(1)
2315: INTO l_msni_count
2316: FROM mtl_serial_numbers_interface
2317: WHERE product_transaction_id = p_transaction_temp_id
2318: AND product_code = 'RCV';
2319: END IF;
2320: IF (l_msni_count = 0) THEN

Line 3946: FROM mtl_serial_numbers_interface

3942: BEGIN
3943: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3944: SELECT count(1)
3945: INTO l_msni_count
3946: FROM mtl_serial_numbers_interface
3947: WHERE product_transaction_id = p_transaction_temp_id
3948: AND product_code = 'RCV';
3949: END IF;
3950:

Line 4195: FROM mtl_serial_numbers

4191: -- bug 2182881
4192: -- added nvl around the cursor
4193: SELECT serial_number
4194: , status_id
4195: FROM mtl_serial_numbers
4196: WHERE inventory_item_id = v_inventory_item_id
4197: AND (revision = v_revision
4198: OR(revision IS NULL
4199: AND v_revision IS NULL))

Line 4243: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

4239: l_primary_uom_code VARCHAR2(3);
4240: l_primary_qty NUMBER;
4241: l_uom_conv_ratio NUMBER;
4242: l_serial_number VARCHAR2(30);
4243: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
4244: l_serial_number_count NUMBER;
4245: l_label_status VARCHAR2(500);
4246: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4247:

Line 4475: INSERT INTO mtl_serial_numbers_temp

4471:
4472: CLOSE l_curs_serial_number;
4473: l_progress := '47';
4474: FORALL i IN 1 .. l_msnt_transaction_temp_id.COUNT
4475: INSERT INTO mtl_serial_numbers_temp
4476: (
4477: transaction_temp_id
4478: , last_update_date
4479: , last_updated_by

Line 4496: UPDATE mtl_serial_numbers

4492: , l_msnt_to_serial_number(i)
4493: );
4494: l_progress := '48';
4495: FORALL i IN 1 .. l_msnt_transaction_temp_id.COUNT
4496: UPDATE mtl_serial_numbers
4497: SET group_mark_id = l_serial_txn_temp_id
4498: WHERE inventory_item_id = l_inventory_item_id
4499: AND serial_number = l_msnt_fm_serial_number(i);
4500: l_progress := '49';