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.AHL_DI_DOC_REVISION_PVT dependencies on AHL_DOCUMENTS_B

Line 72: FROM AHL_DOCUMENTS_B

68: -- Used to validate the document id
69: CURSOR check_doc_info(c_document_id NUMBER)
70: IS
71: SELECT 'X'
72: FROM AHL_DOCUMENTS_B
73: WHERE document_id = c_document_id;
74:
75: -- Retrieves doc revision record
76: CURSOR get_doc_revision_rec_info (c_doc_revision_id NUMBER)

Line 1615: from ahl_doc_title_assos_b asso,ahl_documents_b doc

1611: --Cursor to get ids of all the documents which are associated with use latest flag ='Yes'.
1612: CURSOR get_all_document_ids
1613: IS
1614: select distinct(asso.document_id),doc.document_no
1615: from ahl_doc_title_assos_b asso,ahl_documents_b doc
1616: where asso.use_latest_rev_flag='Y'
1617: and asso.document_id=doc.document_id;
1618:
1619: l_api_version NUMBER :=1.0;