DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_NTF_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 755: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,

751: IS
752: SELECT EngineeringChangeEO.change_id,
753: EngineeringChangeEO.change_mgmt_type_code ,
754: ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE
755: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,
756: ENG_CHANGE_ORDER_TYPES ChangeCategory
757: WHERE ( ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE = 'ATTACHMENT_APPROVAL'
758: OR ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE = 'ATTACHMENT_REVIEW'
759: OR NOT EXISTS (select null