APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on WMS_MATERIAL_TXN_TRACE

Line 1227: insert into WMS_MATERIAL_TXN_TRACE

1223: ---
1224:
1225: If ( l_txn_header_id > 0) then
1226:
1227: insert into WMS_MATERIAL_TXN_TRACE
1228: (
1229: TRANSACTION_HEADER_ID ,
1230: TRANSACTION_TEMP_ID ,
1231: SOURCE_CODE ,

Line 1875: from wms_material_txn_trace

1871: SECONDARY_UNIT_OF_MEASURE ,
1872: QC_GRADE
1873: from mtl_transaction_lots_temp
1874: where transaction_temp_id in ( select transaction_temp_id
1875: from wms_material_txn_trace
1876: where transaction_header_id = l_txn_header_id);
1877:
1878:
1879: End if;

Line 2038: from wms_material_txn_trace

2034: CYCLES_SINCE_MARK ,
2035: NUMBER_OF_REPAIRS
2036: from mtl_serial_numbers_temp
2037: where transaction_temp_id in ( select transaction_temp_id
2038: from wms_material_txn_trace
2039: where transaction_header_id = l_txn_header_id);
2040:
2041:
2042: End if;

Line 2201: from wms_material_txn_trace wmtt,

2197: CYCLES_SINCE_MARK ,
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;