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

Line 469: FROM ahl_doc_revisions_b

465:
466: CURSOR GetDocRevId (c_document_id VARCHAR2)
467: IS
468: SELECT doc_revision_id
469: FROM ahl_doc_revisions_b
470: WHERE document_id = c_document_id;
471:
472: CURSOR GetDocRevCount (c_document_id VARCHAR2)
473: IS

Line 475: FROM ahl_doc_revisions_b

471:
472: CURSOR GetDocRevCount (c_document_id VARCHAR2)
473: IS
474: SELECT count(*)
475: FROM ahl_doc_revisions_b
476: WHERE document_id = c_document_id;
477:
478: CURSOR GetDocRevNoId (c_document_id NUMBER, c_doc_rev_no VARCHAR2)
479: IS

Line 481: FROM ahl_doc_revisions_b

477:
478: CURSOR GetDocRevNoId (c_document_id NUMBER, c_doc_rev_no VARCHAR2)
479: IS
480: SELECT doc_revision_id
481: FROM ahl_doc_revisions_b
482: WHERE document_id = c_document_id
483: and revision_no= c_doc_rev_no;
484:
485: