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_WORKFLOW_UTIL dependencies on ENG_CHANGE_ROUTE_STEPS

Line 1000: , ENG_CHANGE_ROUTE_STEPS step

996: IS
997: SELECT EngSecPeople.user_name user_role
998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
999: , ENG_CHANGE_ROUTE_PEOPLE step_people
1000: , ENG_CHANGE_ROUTE_STEPS step
1001: WHERE EngSecPeople.person_id = step_people.assignee_id
1002: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1003: AND step_people.assignee_id <> -1
1004: AND step_people.step_id = step.step_id

Line 1403: , ENG_CHANGE_ROUTE_STEPS step

1399: IS
1400: SELECT EngSecPeople.user_name user_role
1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1402: , ENG_CHANGE_ROUTE_PEOPLE step_people
1403: , ENG_CHANGE_ROUTE_STEPS step
1404: WHERE EngSecPeople.person_id = step_people.assignee_id
1405: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON
1406: AND step_people.assignee_id <> -1
1407: AND step_people.step_id = step.step_id

Line 2074: ENG_CHANGE_ROUTE_STEPS RouteStep

2070: WfActAttr2.TEXT_DEFAULT ACTIVITY_CONDITION_CODE
2071: FROM WF_ACTIVITIES WfAct,
2072: WF_ACTIVITY_ATTRIBUTES WfActAttr,
2073: WF_ACTIVITY_ATTRIBUTES WfActAttr2,
2074: ENG_CHANGE_ROUTE_STEPS RouteStep
2075: WHERE WfActAttr.NAME (+)= 'DEFAULT_CHANGE_ROLE'
2076: AND WfActAttr.ACTIVITY_VERSION (+)= WfAct.VERSION
2077: AND WfActAttr.ACTIVITY_ITEM_TYPE (+)= WfAct.ITEM_TYPE
2078: AND WfActAttr.ACTIVITY_NAME (+)= WfAct.NAME

Line 2122: , ENG_CHANGE_ROUTE_STEPS RouteStep

2118: FROM FND_MENUS doc_role
2119: , WF_ACTIVITIES WfAct
2120: , WF_ACTIVITY_ATTRIBUTES document_role_attr
2121: , WF_ACTIVITY_ATTRIBUTES cs_role_attr
2122: , ENG_CHANGE_ROUTE_STEPS RouteStep
2123: WHERE doc_role.MENU_NAME (+)= document_role_attr.TEXT_DEFAULT
2124: AND document_role_attr.NAME (+)= 'AUTO_GRANT_DOCUMENT_ROLE'
2125: AND document_role_attr.ACTIVITY_VERSION (+)= WfAct.VERSION
2126: AND document_role_attr.ACTIVITY_ITEM_TYPE (+)= WfAct.ITEM_TYPE

Line 2163: , ENG_CHANGE_ROUTE_STEPS RouteStep

2159: IS
2160: SELECT vote_option_attr.TEXT_DEFAULT VOTE_OPTION
2161: FROM WF_ACTIVITIES WfAct
2162: , WF_ACTIVITY_ATTRIBUTES vote_option_attr
2163: , ENG_CHANGE_ROUTE_STEPS RouteStep
2164: WHERE vote_option_attr.NAME (+)= 'VOTE_OPTION_FOR_STEP_ALL'
2165: AND vote_option_attr.ACTIVITY_VERSION (+)= WfAct.VERSION
2166: AND vote_option_attr.ACTIVITY_ITEM_TYPE (+)= WfAct.ITEM_TYPE
2167: AND vote_option_attr.ACTIVITY_NAME (+)= WfAct.NAME

Line 2199: , ENG_CHANGE_ROUTE_STEPS RouteStep

2195: IS
2196: SELECT vote_option_attr.TEXT_DEFAULT VOTE_OPTION
2197: FROM WF_ACTIVITIES WfAct
2198: , WF_ACTIVITY_ATTRIBUTES vote_option_attr
2199: , ENG_CHANGE_ROUTE_STEPS RouteStep
2200: WHERE vote_option_attr.NAME (+)= 'DEFAULT_ASSIGNEE_RESP_CODE'
2201: AND vote_option_attr.ACTIVITY_VERSION (+)= WfAct.VERSION
2202: AND vote_option_attr.ACTIVITY_ITEM_TYPE (+)= WfAct.ITEM_TYPE
2203: AND vote_option_attr.ACTIVITY_NAME (+)= WfAct.NAME

Line 2239: FROM ENG_CHANGE_ROUTE_STEPS RouteStep

2235:
2236: CURSOR c_step (p_step_id NUMBER)
2237: IS
2238: SELECT required_relative_days
2239: FROM ENG_CHANGE_ROUTE_STEPS RouteStep
2240: WHERE RouteStep.step_id = p_step_id ;
2241:
2242:
2243: BEGIN

Line 3952: ENG_CHANGE_ROUTE_STEPS_VL Step

3948: , TRUNC(Step.required_date) required_date
3949: , ConditionTypeLookup.meaning condition_type
3950: , Step.instruction
3951: FROM FND_LOOKUPS ConditionTypeLookup ,
3952: ENG_CHANGE_ROUTE_STEPS_VL Step
3953: WHERE ConditionTypeLookup.lookup_code = Step.condition_type_code
3954: AND ConditionTypeLookup.lookup_type = 'ENG_CHANGE_ROUTE_CONDITIONS'
3955: AND Step.step_id = p_route_step_id ;
3956:

Line 4621: update ENG_CHANGE_ROUTE_STEPS set

4617: l_set_end_date_flag := 1 ;
4618:
4619: END IF ;
4620:
4621: update ENG_CHANGE_ROUTE_STEPS set
4622: WF_ITEM_TYPE = p_item_type ,
4623: WF_ITEM_KEY = p_item_key,
4624: STEP_STATUS_CODE = p_new_status_code,
4625: STEP_START_DATE = DECODE(l_set_start_date_flag, 1, SYSDATE,STEP_START_DATE),

Line 4716: FROM ENG_CHANGE_ROUTE_STEPS

4712:
4713: CURSOR c_step (p_route_step_id NUMBER)
4714: IS
4715: SELECT step_status_code
4716: FROM ENG_CHANGE_ROUTE_STEPS
4717: WHERE step_id = p_route_step_id ;
4718:
4719: recinfo c_step%rowtype;
4720:

Line 5746: FROM ENG_CHANGE_ROUTE_STEPS

5742: IS
5743:
5744: SELECT step_seq_num
5745: , required_date
5746: FROM ENG_CHANGE_ROUTE_STEPS
5747: WHERE route_id = p_route_id
5748: AND required_date IS NOT NULL
5749: ORDER BY step_seq_num ;
5750:

Line 5938: FROM ENG_CHANGE_ROUTE_STEPS step

5934: CURSOR c_route_assignees (p_route_id NUMBER)
5935: IS
5936:
5937: SELECT step.step_seq_num
5938: FROM ENG_CHANGE_ROUTE_STEPS step
5939: WHERE EXISTS (SELECT 'Invalid Assignee Exists'
5940: FROM ENG_CHANGE_ROUTE_PEOPLE people
5941: WHERE people.assignee_id = -1
5942: AND people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 6022: FROM ENG_CHANGE_ROUTE_STEPS steps ,

6018: IS
6019: CURSOR c_Mandatory_route_assignees (p_route_id NUMBER)
6020: IS
6021: SELECT steps.STEP_SEQ_NUM ,steps.step_id
6022: FROM ENG_CHANGE_ROUTE_STEPS steps ,
6023: ENG_CHANGE_ROUTE_PEOPLE PEOPLE
6024: WHERE CONDITION_TYPE_CODE = 'PEOPLE'
6025: AND STEPS.STEP_ID = PEOPLE.STEP_ID
6026: AND PEOPLE.RESPONSE_CONDITION_CODE = 'MANDATORY'

Line 8737: FROM ENG_CHANGE_ROUTE_STEPS

8733: SELECT step_id,
8734: step_seq_num,
8735: wf_item_type,
8736: wf_process_name
8737: FROM ENG_CHANGE_ROUTE_STEPS
8738: WHERE route_id = p_route_id
8739: AND step_status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
8740: AND step_start_date IS NULL
8741: AND step_end_date IS NULL

Line 14461: FROM ENG_CHANGE_ROUTE_STEPS RouteStep

14457:
14458: CURSOR c_route_step( c_route_id NUMBER )
14459: IS
14460: SELECT RouteStep.STEP_ID
14461: FROM ENG_CHANGE_ROUTE_STEPS RouteStep
14462: WHERE ( RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_NOT_STARTED
14463: AND RouteStep.STEP_STATUS_CODE <> Eng_Workflow_Util.G_RT_IN_PROGRESS)
14464: AND RouteStep.ROUTE_ID = c_route_id ;
14465:

Line 14598: , ENG_CHANGE_ROUTE_STEPS RouteStep

14594: , RoutePeople.RESPONSE_CONDITION_CODE
14595: , TO_CHAR(NULL) ORIG_ROLE_OBJECT_NAME
14596: , TO_NUMBER(NULL) ORIG_ROLE_OBJECT_ID
14597: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14598: , ENG_CHANGE_ROUTE_STEPS RouteStep
14599: WHERE RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'
14600: AND RoutePeople.ASSIGNEE_ID <> -1
14601: AND RoutePeople.ORIGINAL_ASSIGNEE_TYPE_CODE <> 'ROLE'
14602: AND RoutePeople.STEP_ID = RouteStep.STEP_ID

Line 14621: , ENG_CHANGE_ROUTE_STEPS RouteStep

14617: FROM FND_FORM_FUNCTIONS fnd_func
14618: , FND_MENU_ENTRIES fnd_menu
14619: , FND_OBJECTS fnd_obj
14620: , ENG_CHANGE_ROUTE_PEOPLE RoutePeople
14621: , ENG_CHANGE_ROUTE_STEPS RouteStep
14622: WHERE fnd_obj.OBJECT_ID = fnd_func.OBJECT_ID
14623: AND fnd_func.FUNCTION_ID = fnd_menu.FUNCTION_ID
14624: AND fnd_menu.MENU_ID = ORIGINAL_ASSIGNEE_ID
14625: AND RoutePeople.ASSIGNEE_TYPE_CODE = 'PERSON'