APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS

Line 2232: FROM mtl_serial_numbers_interface

2228: BEGIN
2229: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2230: SELECT count(1)
2231: INTO l_msni_count
2232: FROM mtl_serial_numbers_interface
2233: WHERE product_transaction_id = p_transaction_temp_id
2234: AND product_code = 'RCV';
2235: END IF;
2236: IF (l_msni_count = 0) THEN

Line 3806: FROM mtl_serial_numbers_interface

3802: BEGIN
3803: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3804: SELECT count(1)
3805: INTO l_msni_count
3806: FROM mtl_serial_numbers_interface
3807: WHERE product_transaction_id = p_transaction_temp_id
3808: AND product_code = 'RCV';
3809: END IF;
3810:

Line 4053: FROM mtl_serial_numbers

4049: -- bug 2182881
4050: -- added nvl around the cursor
4051: SELECT serial_number
4052: , status_id
4053: FROM mtl_serial_numbers
4054: WHERE inventory_item_id = v_inventory_item_id
4055: AND (revision = v_revision
4056: OR(revision IS NULL
4057: AND v_revision IS NULL))

Line 4101: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

4097: l_primary_uom_code VARCHAR2(3);
4098: l_primary_qty NUMBER;
4099: l_uom_conv_ratio NUMBER;
4100: l_serial_number VARCHAR2(30);
4101: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
4102: l_serial_number_count NUMBER;
4103: l_label_status VARCHAR2(500);
4104: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4105:

Line 4331: INSERT INTO mtl_serial_numbers_temp

4327:
4328: CLOSE l_curs_serial_number;
4329: l_progress := '47';
4330: FORALL i IN 1 .. l_msnt_transaction_temp_id.COUNT
4331: INSERT INTO mtl_serial_numbers_temp
4332: (
4333: transaction_temp_id
4334: , last_update_date
4335: , last_updated_by

Line 4352: UPDATE mtl_serial_numbers

4348: , l_msnt_to_serial_number(i)
4349: );
4350: l_progress := '48';
4351: FORALL i IN 1 .. l_msnt_transaction_temp_id.COUNT
4352: UPDATE mtl_serial_numbers
4353: SET group_mark_id = l_serial_txn_temp_id
4354: WHERE inventory_item_id = l_inventory_item_id
4355: AND serial_number = l_msnt_fm_serial_number(i);
4356: l_progress := '49';