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

Line 580: AHL_WORKORDERS WO, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV

576: SELECT
577: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
578: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
579: FROM
580: AHL_WORKORDERS WO, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
581: WHERE
582: WO.ROUTE_ID = DOC.ASO_OBJECT_ID
583: AND WO.WORKORDER_ID = p_WorkorderId
584: AND DOC.ASO_OBJECT_TYPE_CODE = 'ROUTE'

Line 593: AHL_WORKORDER_OPERATIONS WOP, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV

589: SELECT
590: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
591: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
592: FROM
593: AHL_WORKORDER_OPERATIONS WOP, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
594: WHERE
595: WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
596: AND WOP.WORKORDER_ID = p_WorkorderId
597: AND DOC.ASO_OBJECT_TYPE_CODE = 'OPERATION'

Line 606: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV

602: SELECT
603: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
604: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
605: FROM
606: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
607: WHERE
608: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID
609: AND WO.WORKORDER_ID = p_WorkorderId
610: AND VST.MR_ID = DOC.ASO_OBJECT_ID

Line 621: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV

617: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
618: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
619: FROM
620: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,
621: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
622: WHERE
623: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID
624: AND WO.WORKORDER_ID = p_WorkorderId
625: AND VTS.INSTANCE_ID = CSI.SUBJECT_ID

Line 639: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV

635: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
636: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
637: FROM
638: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,
639: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
640: WHERE
641: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
642: AND WO.WORKORDER_ID = p_WorkorderId
643: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID