eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_STREAM_TRX_DATA

Line 496: FROM okl_stream_trx_data trx,

492: -- And make sure that the same contract was not upgraded successfully later on
493: AND NOT EXISTS
494: (
495: SELECT 1
496: FROM okl_stream_trx_data trx,
497: okl_stream_interfaces osi
498: WHERE osi.transaction_number = trx.transaction_number
499: AND osi.khr_id = chr.id
500: AND trx.last_trx_state = 'Y'

Line 670: || ' AND NOT EXISTS ( SELECT 1 FROM okl_stream_trx_data trx, okl_stream_interfaces osi '

666: -- Predicate to check whether this contract has the PRM content already or not
667: IF p_criteria_set IN ( 'CONTRACT' )
668: THEN
669: l_query_string := l_query_string
670: || ' AND NOT EXISTS ( SELECT 1 FROM okl_stream_trx_data trx, okl_stream_interfaces osi '
671: || ' WHERE osi.transaction_number = trx.transaction_number AND osi.khr_id = chr.id '
672: || ' AND ( ( trx.last_trx_state = ''Y'' AND '
673: || ' ((osi.orp_code = ''UPGRADE'' AND osi.sis_code = ''PROCESS_COMPLETE'') OR '
674: || ' (osi.orp_code = ''AUTH'' AND osi.sis_code = ''PROCESS_COMPLETE'')) ) OR '

Line 817: FROM okl_stream_trx_data trx,

813: AND opp.assigned_process = TO_CHAR(l_seq_next)
814: AND EXISTS
815: (
816: SELECT 'CLOB_EXISTS'
817: FROM okl_stream_trx_data trx,
818: okl_stream_interfaces osi
819: WHERE osi.transaction_number = trx.transaction_number
820: AND osi.khr_id = opp.khr_id
821: AND ( ( trx.last_trx_state = 'Y'