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.OKC_TERMS_UTIL_GRP dependencies on OKC_BUS_VARIABLES_B

Line 307: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

303: IF l_doc_type_tbl.COUNT > 0 THEN
304: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
305: DELETE FROM OKC_K_ART_VAR_EXT_TL
306: WHERE cat_id IN
307: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
308: WHERE document_type=l_doc_type_tbl(i)
309: and document_id=l_doc_id_tbl(i)
310: AND BUSVAR.mrv_flag='Y'
311: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 317: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

313:
314: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
315: DELETE FROM OKC_K_ART_VAR_EXT_B
316: WHERE cat_id IN
317: ( SELECT KART.ID FROM OKC_K_ARTICLES_B KART, OKC_K_ART_VARIABLES ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
318: WHERE document_type=l_doc_type_tbl(i)
319: and document_id=l_doc_id_tbl(i)
320: AND BUSVAR.mrv_flag='Y'
321: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 334: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

330:
331: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
332: DELETE FROM OKC_K_ART_VAR_EXT_TLH
333: WHERE cat_id IN
334: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
335: WHERE document_type=l_doc_type_tbl(i)
336: and document_id=l_doc_id_tbl(i)
337: AND BUSVAR.mrv_flag='Y'
338: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 345: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

341:
342: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
343: DELETE FROM OKC_K_ART_VAR_EXT_BH
344: WHERE cat_id IN
345: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
346: WHERE document_type=l_doc_type_tbl(i)
347: and document_id=l_doc_id_tbl(i)
348: AND BUSVAR.mrv_flag='Y'
349: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE