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_INTERFACES

Line 477: ,okl_stream_interfaces sif

473: ,okl_k_headers khr
474: ,okl_products pdt
475: ,okl_ae_tmpt_sets_all aes
476: ,okl_st_gen_tmpt_sets_all gts
477: ,okl_stream_interfaces sif
478: ,fnd_lookups lkup
479: WHERE chr.id = khr.id
480: AND chr.scs_code = 'LEASE'
481: AND chr.template_yn = 'N'

Line 497: okl_stream_interfaces osi

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'
501: )

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 818: okl_stream_interfaces osi

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'
822: AND ( (osi.orp_code = 'UPGRADE' AND osi.sis_code = 'PROCESS_COMPLETE')