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_DOC_REVISIONS_B

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 449: FROM AHL_DOC_REVISIONS_B a

445:
446: CURSOR GetRevCheck(c_revision_no VARCHAR2)
447: IS
448: SELECT count(a.revision_no)
449: FROM AHL_DOC_REVISIONS_B a
450: WHERE upper(a.revision_no)=upper(c_revision_no);
451:
452: CURSOR GetdocCount(c_document_no VARCHAR2)
453: IS

Line 455: FROM AHL_DOCUMENTS_B a,AHL_DOC_REVISIONS_B b

451:
452: CURSOR GetdocCount(c_document_no VARCHAR2)
453: IS
454: SELECT count(a.document_no)
455: FROM AHL_DOCUMENTS_B a,AHL_DOC_REVISIONS_B b
456: WHERE upper(a.document_no)=upper(c_document_no)
457: and a.document_id=b.document_id;
458:
459:

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:

Line 566: FROM ahl_documents_b a ,AHL_DOC_REVISIONS_B b

562: IF l_check_flag='Y'
563: Then
564:
565: SELECT count(a.document_no) into l_counter3
566: FROM ahl_documents_b a ,AHL_DOC_REVISIONS_B b
567: WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
568: AND upper(a.document_no)=upper(p_x_association_tbl(i).document_no);
569:
570: IF l_counter3=0

Line 710: FROM AHL_DOC_REVISIONS_B

706: IS
707: SELECT REVISION_STATUS_CODE,
708: OBSOLETE_DATE,
709: REVISION_NO
710: FROM AHL_DOC_REVISIONS_B
711: WHERE DOC_REVISION_ID = c_doc_revision_id;
712:
713: l_Rev_rec1 GetRevDet%rowtype;
714: