eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_VALIDATE_ECO dependencies on ENG_CHANGE_ORDER_TYPES

Line 194: from eng_change_order_types

190: , p_organization_id => p_organization_id
191: );
192: select assembly_type
193: into l_new_assembly_type
194: from eng_change_order_types
195: where change_order_type_id =
196: p_new_change_order_type_id;
197:
198: IF l_new_assembly_type = l_assembly_type

Line 477: -- requestor_role_id ,assignee_role_id now not in table ENG_CHANGE_ORDER_TYPES

473: l_process_name VARCHAR2(30) := NULL;
474: l_rev_items_scheduled BOOLEAN := FALSE;
475: l_change_order_type_same NUMBER := 0;
476: l_change_order_access BOOLEAN := FALSE;
477: -- requestor_role_id ,assignee_role_id now not in table ENG_CHANGE_ORDER_TYPES
478: /* l_requestor_role_id NUMBER;
479: l_assignee_role_id NUMBER; */
480: l_requestor_role_name VARCHAR2(30);
481: l_assignee_role_name VARCHAR2(30);

Line 1023: /* commented as assignee_role_id ,requestor_role_id don't exist in ENG_CHANGE_ORDER_TYPES table

1019: l_return_status := FND_API.G_RET_STS_ERROR;
1020:
1021: END IF ;
1022:
1023: /* commented as assignee_role_id ,requestor_role_id don't exist in ENG_CHANGE_ORDER_TYPES table
1024: IF p_ECO_rec.transaction_type = Eng_Globals.G_OPR_CREATE
1025: THEN
1026:
1027: IF p_Unexp_ECO_Rec.Requestor_Id IS NULL AND p_Unexp_ECO_Rec.Assignee_Id IS NULL

Line 1042: FROM eng_change_order_types

1038:
1039:
1040: SELECT requestor_role_id, assignee_role_id
1041: INTO l_requestor_role_id, l_assignee_role_id
1042: FROM eng_change_order_types
1043: WHERE change_order_type_id = p_Unexp_ECO_Rec.change_order_type_id;
1044:
1045: IF l_requestor_role_id IS NOT NULL
1046: THEN

Line 1230: l_base_change_mgmt_type_code ENG_CHANGE_ORDER_TYPES.base_change_mgmt_type_code%TYPE;

1226:
1227: l_valid_status NUMBER;
1228: l_valid_priority NUMBER;
1229: l_valid_reason NUMBER;
1230: l_base_change_mgmt_type_code ENG_CHANGE_ORDER_TYPES.base_change_mgmt_type_code%TYPE;
1231:
1232: BEGIN
1233:
1234: l_token_tbl(1).token_name := 'ECO_NAME';

Line 1379: SELECT base_change_mgmt_type_code into l_base_change_mgmt_type_code from eng_change_order_types where change_order_type_id = p_Unexp_ECO_rec.Change_Order_Type_Id;

1375: -- Change objects other than change order and change order based can be created in any phase other than Open also.
1376: -- So we need to check the base change management type code for change order before checking this validation
1377:
1378: -- Get the base change mgmt type code
1379: SELECT base_change_mgmt_type_code into l_base_change_mgmt_type_code from eng_change_order_types where change_order_type_id = p_Unexp_ECO_rec.Change_Order_Type_Id;
1380:
1381: IF p_ECO_rec.transaction_type = 'CREATE' and l_base_change_mgmt_type_code = 'CHANGE_ORDER' and
1382: ((nvl(p_ECO_rec.plm_or_erp_change,'PLM') = 'ERP' AND p_Unexp_ECO_rec.status_type <> 1 AND p_Unexp_ECO_rec.status_type <> 4 AND p_Unexp_ECO_rec.status_type <> 11)
1383: OR (nvl(p_ECO_rec.plm_or_erp_change,'PLM') = 'PLM' AND p_Unexp_ECO_rec.status_type NOT IN (0,1,4,11)))

Line 2484: FROM eng_change_order_types

2480: IF Eng_Globals.Is_ECO_Access IS NULL
2481: THEN
2482: SELECT assembly_type
2483: INTO l_change_order_assembly_Type
2484: FROM eng_change_order_types
2485: WHERE change_order_type_id =
2486: l_change_order_type_id;
2487:
2488: IF l_change_order_assembly_type = 2 /* ENG */