APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS

Line 3009: FROM mtl_serial_numbers_interface

3005: BEGIN
3006: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3007: SELECT count(1)
3008: INTO l_msni_count
3009: FROM mtl_serial_numbers_interface
3010: WHERE product_transaction_id = p_original_rti_id
3011: AND product_code = 'RCV';
3012: END IF;
3013:

Line 4650: FROM mtl_serial_numbers_interface

4646: BEGIN
4647: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
4648: SELECT count(1)
4649: INTO l_msni_count
4650: FROM mtl_serial_numbers_interface
4651: WHERE product_transaction_id = p_original_rti_id
4652: AND product_code = 'RCV';
4653: END IF;
4654:

Line 4883: FROM mtl_serial_numbers

4879: CURSOR l_curs_serial_number(v_inventory_item_id NUMBER, v_revision VARCHAR2
4880: , v_lot_number VARCHAR2, v_lpn_id NUMBER) IS
4881: SELECT serial_number,
4882: status_id
4883: FROM mtl_serial_numbers
4884: WHERE inventory_item_id = v_inventory_item_id
4885: AND(revision = v_revision
4886: OR(revision IS NULL
4887: AND v_revision IS NULL))

Line 4917: l_serial_number mtl_serial_numbers.serial_number%type;

4913: l_serial_control_code NUMBER;
4914: l_transaction_interface_id NUMBER;
4915: l_product_transaction_id NUMBER;
4916: l_serial_transaction_temp_id NUMBER;
4917: l_serial_number mtl_serial_numbers.serial_number%type;
4918: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
4919: l_lot_prm_quantity NUMBER; --lot quantity in primary uom
4920: l_lot_status_id NUMBER;
4921: l_serial_status_id NUMBER;

Line 8257: UPDATE mtl_serial_numbers

8253: DELETE wms_lpn_contents
8254: WHERE parent_lpn_id = p_lpn_id;
8255:
8256: -- clear serial numbers table
8257: UPDATE mtl_serial_numbers
8258: SET lpn_id = NULL
8259: WHERE lpn_id = p_lpn_id;
8260:
8261: l_progress := '20';

Line 8975: FROM mtl_serial_numbers

8971: AND parent_lpn_id = p_lpn_id;
8972:
8973: CURSOR lpn_serial_items IS
8974: SELECT DISTINCT inventory_item_id
8975: FROM mtl_serial_numbers
8976: WHERE lpn_id = p_lpn_id;
8977: BEGIN
8978: IF (l_debug = 1) THEN
8979: print_debug('Enter update_LPN_Org 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 9039: UPDATE mtl_serial_numbers

9035: AND inventory_item_id = l_item_id;
9036:
9037: IF l_serial_code IN(2, 5) THEN
9038: -- bug 2167174
9039: UPDATE mtl_serial_numbers
9040: SET current_organization_id = p_organization_id
9041: WHERE lpn_id = p_lpn_id
9042: AND inventory_item_id = l_item_id; /* 3835398 */
9043: