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_SECTIONS_B

Line 289: DELETE FROM OKC_SECTIONS_B

285: WHERE document_type=l_doc_type_tbl(i)
286: and document_id=l_doc_id_tbl(i);
287:
288: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
289: DELETE FROM OKC_SECTIONS_B
290: WHERE document_type=l_doc_type_tbl(i)
291: and document_id=l_doc_id_tbl(i);
292:
293: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 294: DELETE FROM OKC_SECTIONS_BH

290: WHERE document_type=l_doc_type_tbl(i)
291: and document_id=l_doc_id_tbl(i);
292:
293: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
294: DELETE FROM OKC_SECTIONS_BH
295: WHERE document_type=l_doc_type_tbl(i)
296: and document_id=l_doc_id_tbl(i);
297:
298: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 1592: FROM OKC_SECTIONS_B

1588: AND DOCUMENT_ID=p_doc_id;
1589:
1590: Cursor l_get_max_scn_date_csr IS
1591: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1592: FROM OKC_SECTIONS_B
1593: WHERE DOCUMENT_TYPE=p_doc_type
1594: AND DOCUMENT_ID=p_doc_id;
1595:
1596: Cursor l_get_max_art_hist_date_csr IS

Line 1604: FROM OKC_SECTIONS_BH

1600: AND DOCUMENT_ID=p_doc_id;
1601:
1602: Cursor l_get_max_scn_hist_date_csr IS
1603: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1604: FROM OKC_SECTIONS_BH
1605: WHERE DOCUMENT_TYPE=p_doc_type
1606: AND DOCUMENT_ID=p_doc_id;
1607:
1608: Cursor l_get_contract_source_csr IS