APPS.ENG_WORKFLOW_UTIL dependencies on ENG_CHANGE_ORDER_TYPES

Line 1688: -- FROM ENG_CHANGE_ORDER_TYPES ecmt,

1684: AND eec.change_id = p_change_id ;
1685:
1686: -- SELECT 'Y' AS enable_rev_items_flag -- ecmt.enable_rev_items_flag
1687: -- , 'Y' AS enable_tasks_flag -- ecmt.enable_tasks_flag
1688: -- FROM ENG_CHANGE_ORDER_TYPES ecmt,
1689: -- ENG_ENGINEERING_CHANGES eec
1690: -- WHERE ecmt.change_mgmt_type_code = eec.change_mgmt_type_code
1691: -- AND type_classification = 'CATEGORY'
1692: -- AND eec.change_id = p_change_id ;

Line 2444: ENG_CHANGE_ORDER_TYPES ChangeCategory

2440: CURSOR c_base_cm_code(p_change_id NUMBER)
2441: IS
2442: SELECT ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE
2443: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,
2444: ENG_CHANGE_ORDER_TYPES ChangeCategory
2445: WHERE ChangeCategory.type_classification = 'CATEGORY'
2446: AND ChangeCategory.change_mgmt_type_code = EngineeringChangeEO.change_mgmt_type_code
2447: AND EngineeringChangeEO.change_id = p_change_id ;
2448:

Line 3482: FROM ENG_CHANGE_ORDER_TYPES_TL ecot,

3478: , l_assignee_id
3479: , l_change_status_type
3480: , l_change_status_code
3481: , l_phase_status_type
3482: FROM ENG_CHANGE_ORDER_TYPES_TL ecot,
3483: -- ENG_CHANGE_PRIORITIES priority,
3484: -- ENG_CHANGE_REASONS reason,
3485: MFG_LOOKUPS ecs,
3486: ENG_CHANGE_STATUSES_VL eclf,

Line 3489: ENG_CHANGE_ORDER_TYPES ecmt,

3485: MFG_LOOKUPS ecs,
3486: ENG_CHANGE_STATUSES_VL eclf,
3487: MFG_LOOKUPS mlu,
3488: HR_ORGANIZATION_UNITS hou,
3489: ENG_CHANGE_ORDER_TYPES ecmt,
3490: ENG_CHANGE_ORDER_TYPES_TL ecmt_tl,
3491: -- ENG_CHANGE_ORDER_TYPES_VL ecmt,
3492: ENG_ENGINEERING_CHANGES eec
3493: WHERE eec.change_order_type_id = ecot.change_order_type_id

Line 3490: ENG_CHANGE_ORDER_TYPES_TL ecmt_tl,

3486: ENG_CHANGE_STATUSES_VL eclf,
3487: MFG_LOOKUPS mlu,
3488: HR_ORGANIZATION_UNITS hou,
3489: ENG_CHANGE_ORDER_TYPES ecmt,
3490: ENG_CHANGE_ORDER_TYPES_TL ecmt_tl,
3491: -- ENG_CHANGE_ORDER_TYPES_VL ecmt,
3492: ENG_ENGINEERING_CHANGES eec
3493: WHERE eec.change_order_type_id = ecot.change_order_type_id
3494: AND ecot.language = userenv('LANG')

Line 3491: -- ENG_CHANGE_ORDER_TYPES_VL ecmt,

3487: MFG_LOOKUPS mlu,
3488: HR_ORGANIZATION_UNITS hou,
3489: ENG_CHANGE_ORDER_TYPES ecmt,
3490: ENG_CHANGE_ORDER_TYPES_TL ecmt_tl,
3491: -- ENG_CHANGE_ORDER_TYPES_VL ecmt,
3492: ENG_ENGINEERING_CHANGES eec
3493: WHERE eec.change_order_type_id = ecot.change_order_type_id
3494: AND ecot.language = userenv('LANG')
3495: -- AND eec.priority_code = priority.eng_change_priority_code(+)

Line 3547: FROM ENG_CHANGE_ORDER_TYPES ecot,

3543: , x_change_managemtent_type
3544: , x_change_order_type
3545: , x_eco_department
3546: , l_assignee_id
3547: FROM ENG_CHANGE_ORDER_TYPES ecot,
3548: -- ENG_CHANGE_PRIORITIES priority,
3549: -- ENG_CHANGE_REASONS reason,
3550: ENG_CHANGE_STATUSES_TL ecs,
3551: MFG_LOOKUPS mlu,