DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_PC_ASSOCIATIONS

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