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_ASSO_DOC_ASO_PUB dependencies on AHL_DOCUMENTS_B

Line 77: FROM AHL_DOCUMENTS_B

73: --Used to retrieve document id
74: CURSOR get_doc_id_info(c_document_no VARCHAR2)
75: IS
76: SELECT document_id
77: FROM AHL_DOCUMENTS_B
78: WHERE document_no = c_document_no;
79: -- Used to retrieve document revision
80: CURSOR get_doc_rev_id_info(c_revision_no VARCHAR2,
81: c_document_id NUMBER)

Line 548: FROM AHL_DOCUMENTS_B

544: --To retrieve document id
545: CURSOR get_doc_id_info(c_document_no VARCHAR2)
546: IS
547: SELECT document_id
548: FROM AHL_DOCUMENTS_B
549: WHERE document_no = c_document_no;
550:
551: --To retrieve count of revisions of the doc
552: CURSOR get_doc_rev_count(c_document_id VARCHAR2)

Line 1051: FROM AHL_DOCUMENTS_B

1047: --To retrieve document id
1048: CURSOR get_doc_id_info(c_document_no VARCHAR2)
1049: IS
1050: SELECT document_id
1051: FROM AHL_DOCUMENTS_B
1052: WHERE document_no = c_document_no;
1053: --To retrieve document revision
1054: CURSOR get_doc_rev_id_info(c_revision_no VARCHAR2,
1055: c_document_id NUMBER)