APPS.AHL_PRD_WO_PUB dependencies on AHL_VISIT_TASKS_B

Line 133: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,

129: VTS.service_request_id service_request_number,
130: WO.HOLD_REASON_CODE,
131: WO.HOLD_REASON
132: FROM AHL_WORKORDER_TASKS_V WO, PA_PROJECTS_ALL PAA, PA_TASKS PAT,
133: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,
134: AHL_VISITS_B VST,AHL_WORKORDERS WOS
135: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
136: AND WO.VISIT_ID=VST.VISIT_ID
137: AND WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)

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 637: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,

633: SELECT DISTINCT
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

Line 654: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,

650: SELECT DISTINCT
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