DBA Data[Home] [Help]

APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on WMS_TRANSACTION_LOTS_TRACE

Line 1688: insert into wms_transaction_lots_trace

1684: where transaction_header_id = l_txn_header_id;
1685: --- If lot controlled item, insert records into lot_trace table
1686:
1687: If (l_insert_lot_flag = 1) then
1688: insert into wms_transaction_lots_trace
1689: (
1690: TRANSACTION_TEMP_ID,
1691: LAST_UPDATE_DATE,
1692: LAST_UPDATED_BY,

Line 2202: wms_transaction_lots_trace wtlt

2198: NUMBER_OF_REPAIRS
2199: from mtl_serial_numbers_temp
2200: where transaction_temp_id in ( select wtlt.serial_transaction_temp_id
2201: from wms_material_txn_trace wmtt,
2202: wms_transaction_lots_trace wtlt
2203: where wmtt.transaction_header_id = l_txn_header_id
2204: and wmtt.transaction_temp_id = wtlt.transaction_temp_id);
2205: End if;
2206: