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_K_ART_VARIABLES_PVT dependencies on OKC_K_ARTICLES_BH

Line 2409: FROM OKC_K_ARTICLES_BH KART

2405:
2406: CURSOR doc_ver_mrv_csr
2407: IS
2408: SELECT kart.ID
2409: FROM OKC_K_ARTICLES_BH KART
2410: , OKC_BUS_VARIABLES_B BUS_VAR
2411: , OKC_K_ART_VARIABLES_H KVAR
2412: WHERE kart.document_type=p_doc_type
2413: AND kart.document_id = p_doc_id

Line 2472: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH

2468: LAST_UPDATE_DATE,
2469: mr_variable_html,
2470: mr_variable_xml
2471: FROM OKC_K_ART_VARIABLES_H
2472: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2473: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2474: AND DOCUMENT_ID = P_DOC_ID)
2475: AND major_version = p_major_version;
2476:

Line 2523: FROM OKC_K_ARTICLES_BH KART

2519: IS
2520: CURSOR doc_ver_mrv_csr
2521: IS
2522: SELECT kart.ID
2523: FROM OKC_K_ARTICLES_BH KART
2524: , OKC_BUS_VARIABLES_B BUS_VAR
2525: , OKC_K_ART_VARIABLES_H KVAR
2526: WHERE kart.document_type=p_doc_type
2527: AND kart.document_id = p_doc_id

Line 2553: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH

2549: END LOOP;
2550:
2551: DELETE
2552: FROM OKC_K_ART_VARIABLES_H
2553: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2554: WHERE document_type = p_doc_type and document_id = p_doc_id)
2555: AND major_version = p_major_version;
2556:
2557: /*IF (l_debug = 'Y') THEN