DBA Data[Home] [Help]

APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2036: from mtl_serial_numbers_temp

2032: CYCLES_SINCE_VISIT ,
2033: TIME_SINCE_MARK ,
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:

Line 2199: from mtl_serial_numbers_temp

2195: CYCLES_SINCE_VISIT ,
2196: TIME_SINCE_MARK ,
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