DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 4787: from mtl_transaction_lots_temp

4783: l_stmt_num := 603;
4784: begin
4785:
4786: select 1 into l_dummy
4787: from mtl_transaction_lots_temp
4788: where lot_number = v_wsli(v_wlji_source_line_id(v_index)).lot_number
4789: and rownum = 1;
4790:
4791: if l_dummy <>0 then

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

4813: If l_dummy <> 0 then
4814: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
4815: FND_MESSAGE.SET_TOKEN('TABLE',
4816: 'Starting Lot:'||v_wsli(v_wlji_source_line_id(v_index)).lot_number
4817: ||'Table: mtl_transaction_lots_temp ');
4818: l_err_msg := fnd_message.get;
4819: l_error_code := -1;
4820: HANDLE_ERROR( l_error_code, l_err_msg, l_stmt_num);
4821: END IF;

Line 7381: INSERT INTO MTL_TRANSACTION_LOTS_TEMP (

7377: end if;
7378:
7379: l_stmt_num := 1160;
7380:
7381: INSERT INTO MTL_TRANSACTION_LOTS_TEMP (
7382: transaction_temp_id,
7383: last_update_date,
7384: creation_date,
7385: last_updated_by,