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_DOCASO_PVT dependencies on AHL_DOCUMENTS_VL

Line 433: FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b

429: a.document_title,
430: b.doc_revision_id,
431: b.revision_no,
432: b.revision_status_code
433: FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b
434: WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
435: and upper(a.document_no)=upper(c_document_no);
436:
437: l_doc_rec GetDocDet%rowtype;

Line 442: FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b

438:
439: CURSOR GetDocCheck(c_document_no VARCHAR2)
440: IS
441: SELECT count(a.document_no)
442: FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b
443: WHERE A.DOCUMENT_ID=B.DOCUMENT_ID(+)
444: and upper(a.document_no)=upper(c_document_no);
445:
446: CURSOR GetRevCheck(c_revision_no VARCHAR2)

Line 470: FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b

466: a.document_title,
467: b.doc_revision_id,
468: b.revision_no,
469: b.revision_status_code
470: FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b
471: WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
472: and A.DOCUMENT_no=c_document_no
473: and b.revision_no=c_revision_no;
474: