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_COPY_CONTRACT_PVT dependencies on OKC_TEMPLATE_USAGES_V

Line 6116: FROM okc_template_usages_v

6112:
6113: -- 11510 get chr start date for effective date for copy_doc
6114: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS
6115: SELECT article_effective_date
6116: FROM okc_template_usages_v
6117: WHERE document_type=p_doc_type AND document_id=p_doc_id;
6118: ---------------------------------------------------
6119: CURSOR c_cplv IS
6120: SELECT id

Line 10434: FROM okc_template_usages_v

10430:
10431: -- 11510 get chr start date for effective date for copy_doc
10432: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS
10433: SELECT article_effective_date
10434: FROM okc_template_usages_v
10435: WHERE document_type=p_doc_type AND document_id=p_doc_id;
10436:
10437: --cursor to fetch id of line with lseid =20 -Bug:3668722
10438: CURSOR c_lines(p NUMBER) IS