APPS.AHL_PRD_WO_PUB dependencies on CSI_II_RELATIONSHIPS

Line 620: AHL_WORKORDERS WO, CSI_II_RELATIONSHIPS CSI, AHL_VISIT_TASKS_B VTS,

616: SELECT
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