APPS.ENGECOBO dependencies on ENG_CHANGE_ORDER_TYPES

Line 2039: FROM eng_change_order_types_v --11.5.10 Changes

2035: IF (eco_rec.change_order_type_id IS NOT NULL) THEN
2036:
2037: SELECT CHANGE_ORDER_TYPE
2038: INTO l_change_type_code
2039: FROM eng_change_order_types_v --11.5.10 Changes
2040: WHERE change_order_type_id = eco_rec.change_order_type_id;
2041:
2042: ELSE
2043:

Line 4175: l_change_mgmt_type Eng_change_order_types_tl.type_name%TYPE; --Bug 3544760

4171: -- Local Identifiers
4172: l_local_change_id NUMBER;
4173: -- Exposed Column Data
4174: l_change_type_code VARCHAR2(80);
4175: l_change_mgmt_type Eng_change_order_types_tl.type_name%TYPE; --Bug 3544760
4176: l_requestor_name VARCHAR2(30);
4177: l_assignee_name VARCHAR2(360);
4178: l_Task_Number VARCHAR2(25);
4179: l_Project_Number VARCHAR2(30);

Line 4196: l_default_assignee_type eng_change_order_types.default_assignee_type%TYPE;

4192: l_approval_status VARCHAR2(80);
4193: l_task_number1 VARCHAR2(100);
4194: l_party_id NUMBER;
4195: l_party_type VARCHAR2(30);
4196: l_default_assignee_type eng_change_order_types.default_assignee_type%TYPE;
4197: l_assignee_role_id NUMBER;
4198: l_status_name eng_change_statuses_tl.status_name%TYPE;
4199: l_department_name VARCHAR2(240);
4200: l_change_type_id NUMBER;

Line 4379: FROM eng_change_order_types_v ecotv

4375: INTO l_change_type_code
4376: , l_change_mgmt_type
4377: , l_default_assignee_type
4378: , l_assignee_role_id
4379: FROM eng_change_order_types_v ecotv
4380: , eng_change_mgmt_types_vl ecmtv
4381: WHERE ecotv.change_order_type_id = eco_rec.change_order_type_id
4382: AND ecotv.CHANGE_MGMT_TYPE_CODE = ecmtv.CHANGE_MGMT_TYPE_CODE;
4383: ELSE