DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 4793: from mtl_transaction_lots_temp

4789: l_stmt_num := 603;
4790: begin
4791:
4792: select 1 into l_dummy
4793: from mtl_transaction_lots_temp
4794: where lot_number = v_wsli(v_wlji_source_line_id(v_index)).lot_number
4795: and rownum = 1;
4796:
4797: if l_dummy <>0 then

Line 4823: ||'Table: mtl_transaction_lots_temp ');

4819: If l_dummy <> 0 then
4820: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4821: FND_MESSAGE.SET_TOKEN('TABLE',
4822: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4823: ||'Table: mtl_transaction_lots_temp ');
4824: l_err_msg := fnd_message.get;
4825: l_error_code := -1;
4826: HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4827: END IF;

Line 7387: INSERT INTO MTL_TRANSACTION_LOTS_TEMP (

7383: end if;
7384:
7385: l_stmt_num := 1160;
7386:
7387: INSERT INTO MTL_TRANSACTION_LOTS_TEMP (
7388: transaction_temp_id,
7389: last_update_date,
7390: creation_date,
7391: last_updated_by,