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_GEN_PVT dependencies on AHL_DOC_REVISIONS_B

Line 25: FROM AHL_DOCUMENTS_B D, AHL_DOC_REVISIONS_B R

21: as
22: CURSOR get_rev_dat(c_document_id NUMBER, c_doc_revision_id NUMBER)
23: IS
24: SELECT DOCUMENT_NO, REVISION_NO
25: FROM AHL_DOCUMENTS_B D, AHL_DOC_REVISIONS_B R
26: WHERE D.DOCUMENT_ID = R.DOCUMENT_ID
27: AND R.DOC_REVISION_ID = c_doc_revision_id
28: AND D.DOCUMENT_ID = c_document_id;
29:

Line 96: FROM AHL_DOC_REVISIONS_B

92: IS
93: SELECT REVISION_STATUS_CODE,
94: OBSOLETE_DATE,
95: REVISION_NO
96: FROM AHL_DOC_REVISIONS_B
97: WHERE DOC_REVISION_ID = c_doc_revision_id;
98:
99: l_Rev_rec1 get_rev_dat%rowtype;
100: