APPS.GML_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS

Line 2829: FROM mtl_serial_numbers

2825: v_lpn_id NUMBER) IS
2826: -- bug 2182881
2827: -- added nvl around the cursor
2828: SELECT serial_number
2829: FROM mtl_serial_numbers
2830: WHERE inventory_item_id = v_inventory_item_id
2831: AND (revision = v_revision OR (revision IS NULL AND
2832: v_revision IS NULL))
2833: AND (lot_number = v_lot_number OR (lot_number IS NULL AND

Line 2877: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

2873: l_primary_uom_code VARCHAR2(3);
2874: l_primary_qty NUMBER;
2875: l_uom_conv_ratio NUMBER;
2876: l_serial_number VARCHAR2(30);
2877: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
2878: l_serial_number_count NUMBER;
2879:
2880: l_label_status VARCHAR2(500);
2881: BEGIN

Line 3022: INSERT INTO mtl_serial_numbers_temp

3018:
3019: l_progress := '47';
3020:
3021: FORALL i IN 1..l_msnt_transaction_temp_id.COUNT
3022: INSERT INTO mtl_serial_numbers_temp
3023: (transaction_temp_id,
3024: last_update_date,
3025: last_updated_by,
3026: creation_date,

Line 3044: UPDATE mtl_serial_numbers

3040:
3041: l_progress := '48';
3042:
3043: FORALL i IN 1..l_msnt_transaction_temp_id.COUNT
3044: UPDATE mtl_serial_numbers
3045: SET group_mark_id = l_serial_txn_temp_id
3046: WHERE inventory_item_id = l_inventory_item_id
3047: AND serial_number = l_msnt_fm_serial_number(i);
3048: