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_DOCUMENT_ASSOS_V

Line 603: AHL_WORKORDERS WO, AHL_DOCUMENT_ASSOS_V DOC

599: SELECT DISTINCT
600: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
601: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
602: FROM
603: AHL_WORKORDERS WO, AHL_DOCUMENT_ASSOS_V DOC
604: WHERE
605: WO.ROUTE_ID = DOC.ASO_OBJECT_ID
606: AND WO.WORKORDER_ID = p_WorkorderId
607: AND DOC.ASO_OBJECT_TYPE_CODE = 'ROUTE'

Line 614: AHL_WORKORDER_OPERATIONS WOP, AHL_DOCUMENT_ASSOS_V DOC

610: SELECT DISTINCT
611: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
612: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
613: FROM
614: AHL_WORKORDER_OPERATIONS WOP, AHL_DOCUMENT_ASSOS_V DOC
615: WHERE
616: WOP.OPERATION_ID = DOC.ASO_OBJECT_ID
617: AND WOP.WORKORDER_ID = p_WorkorderId
618: AND DOC.ASO_OBJECT_TYPE_CODE = 'OPERATION'

Line 625: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, AHL_DOCUMENT_ASSOS_V DOC

621: SELECT DISTINCT
622: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
623: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
624: FROM
625: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B VST, AHL_DOCUMENT_ASSOS_V DOC
626: WHERE
627: WO.VISIT_TASK_ID = VST.VISIT_TASK_ID
628: AND WO.WORKORDER_ID = p_WorkorderId
629: AND VST.MR_ID = DOC.ASO_OBJECT_ID

Line 638: AHL_DOCUMENT_ASSOS_V DOC

634: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
635: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
636: FROM
637: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,
638: AHL_DOCUMENT_ASSOS_V DOC
639: WHERE
640: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID
641: AND WO.WORKORDER_ID = p_WorkorderId
642: AND VTS.INSTANCE_ID = CSI.SUBJECT_ID

Line 655: AHL_DOCUMENT_ASSOS_V DOC

651: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
652: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
653: FROM
654: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,
655: AHL_DOCUMENT_ASSOS_V DOC
656: WHERE
657: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
658: AND WO.WORKORDER_ID = p_WorkorderId
659: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID