APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS

Line 2831: FROM mtl_serial_numbers_interface

2827: */
2828: --9651496,9764650-starts
2829: BEGIN
2830: SELECT fm_serial_number INTO l_serial_number
2831: FROM mtl_serial_numbers_interface
2832: WHERE product_transaction_id = p_original_rti_id ;
2833: EXCEPTION
2834: WHEN No_Data_Found THEN
2835: IF (l_debug = 1) THEN

Line 3172: FROM mtl_serial_numbers_interface

3168: BEGIN
3169: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3170: SELECT count(1)
3171: INTO l_msni_count
3172: FROM mtl_serial_numbers_interface
3173: WHERE product_transaction_id = p_original_rti_id
3174: AND product_code = 'RCV';
3175: END IF;
3176:

Line 4917: FROM mtl_serial_numbers_interface

4913: BEGIN
4914: IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
4915: SELECT count(1)
4916: INTO l_msni_count
4917: FROM mtl_serial_numbers_interface
4918: WHERE product_transaction_id = p_original_rti_id
4919: AND product_code = 'RCV';
4920: END IF;
4921:

Line 5151: FROM mtl_serial_numbers

5147: CURSOR l_curs_serial_number(v_inventory_item_id NUMBER, v_revision VARCHAR2
5148: , v_lot_number VARCHAR2, v_lpn_id NUMBER) IS
5149: SELECT serial_number,
5150: status_id
5151: FROM mtl_serial_numbers
5152: WHERE inventory_item_id = v_inventory_item_id
5153: AND(revision = v_revision
5154: OR(revision IS NULL
5155: AND v_revision IS NULL))

Line 5185: l_serial_number mtl_serial_numbers.serial_number%type;

5181: l_serial_control_code NUMBER;
5182: l_transaction_interface_id NUMBER;
5183: l_product_transaction_id NUMBER;
5184: l_serial_transaction_temp_id NUMBER;
5185: l_serial_number mtl_serial_numbers.serial_number%type;
5186: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5187: l_lot_prm_quantity NUMBER; --lot quantity in primary uom
5188: l_lot_status_id NUMBER;
5189: l_serial_status_id NUMBER;

Line 5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,

5621: END IF;
5622:
5623: select count(1) into
5624: l_msni_count
5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,
5626: wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
5627: mtl_serial_numbers msn -- Bug 16517269
5628: where rti.interface_transaction_id = msni.product_transaction_id
5629: and rsh.shipment_header_id = p_shipment_header_id

Line 5627: mtl_serial_numbers msn -- Bug 16517269

5623: select count(1) into
5624: l_msni_count
5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,
5626: wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
5627: mtl_serial_numbers msn -- Bug 16517269
5628: where rti.interface_transaction_id = msni.product_transaction_id
5629: and rsh.shipment_header_id = p_shipment_header_id
5630: and (lpn.source_header_id = rsh.shipment_header_id
5631: or lpn.source_name = rsh.shipment_num)

Line 8653: UPDATE mtl_serial_numbers

8649: DELETE wms_lpn_contents
8650: WHERE parent_lpn_id = p_lpn_id;
8651:
8652: -- clear serial numbers table
8653: UPDATE mtl_serial_numbers
8654: SET lpn_id = NULL
8655: WHERE lpn_id = p_lpn_id;
8656:
8657: l_progress := '20';

Line 9371: FROM mtl_serial_numbers

9367: AND parent_lpn_id = p_lpn_id;
9368:
9369: CURSOR lpn_serial_items IS
9370: SELECT DISTINCT inventory_item_id
9371: FROM mtl_serial_numbers
9372: WHERE lpn_id = p_lpn_id;
9373: BEGIN
9374: IF (l_debug = 1) THEN
9375: print_debug('Enter update_LPN_Org 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 9435: UPDATE mtl_serial_numbers

9431: AND inventory_item_id = l_item_id;
9432:
9433: IF l_serial_code IN(2, 5) THEN
9434: -- bug 2167174
9435: UPDATE mtl_serial_numbers
9436: SET current_organization_id = p_organization_id
9437: WHERE lpn_id = p_lpn_id
9438: AND inventory_item_id = l_item_id; /* 3835398 */
9439: