DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS_TEMP

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