DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on CSI_II_RELATIONSHIPS

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