DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on ENG_LIFECYCLE_STATUSES

Line 1069: ENG_LIFECYCLE_STATUSES els,

1065:
1066: CURSOR check_eco_route_type(p_change_id NUMBER) IS
1067: SELECT ecr.ROUTE_TYPE_CODE
1068: FROM ENG_ENGINEERING_CHANGES eec,
1069: ENG_LIFECYCLE_STATUSES els,
1070: ENG_CHANGE_ROUTES ecr
1071: WHERE eec.CHANGE_ID = p_change_id
1072: AND els.ENTITY_NAME(+) = 'ENG_CHANGE'
1073: AND els.ENTITY_ID1(+) = eec.CHANGE_ID