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 WF_ACTIVITIES

Line 1918: , WF_ACTIVITIES A

1914: -- , WIAS.ERROR_STACK
1915: into x_activity_status
1916: from WF_ITEM_ACTIVITY_STATUSES WIAS
1917: , WF_PROCESS_ACTIVITIES PA
1918: , WF_ACTIVITIES A
1919: where WIAS.ITEM_TYPE = p_item_type
1920: and WIAS.ITEM_KEY = p_item_key
1921: and WIAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1922: and PA.PROCESS_ITEM_TYPE = p_item_type

Line 2071: FROM WF_ACTIVITIES WfAct,

2067: CURSOR c_step_act_attr (p_step_id NUMBER)
2068: IS
2069: SELECT WfActAttr.TEXT_DEFAULT DEFAULT_ROLE_NAME,
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'

Line 2119: , WF_ACTIVITIES WfAct

2115: SELECT document_role_attr.TEXT_DEFAULT DOCUMENT_ROLE
2116: , doc_role.MENU_ID DOCUMENT_ROLE_ID
2117: , cs_role_attr.TEXT_DEFAULT OCS_ROLE
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

Line 2161: FROM WF_ACTIVITIES WfAct

2157:
2158: CURSOR c_step_act_attr (c_step_id NUMBER)
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

Line 2197: FROM WF_ACTIVITIES WfAct

2193:
2194: CURSOR c_step_act_attr (c_step_id NUMBER)
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

Line 9686: wf_activities wfa,

9682: -- Select all lookup codes for an activities result type
9683: cursor result_codes is
9684: select wfl.lookup_code result_code
9685: from wf_lookups wfl,
9686: wf_activities wfa,
9687: wf_process_activities wfpa,
9688: wf_items wfi
9689: where wfl.lookup_type = wfa.result_type
9690: and wfa.name = wfpa.activity_name

Line 10151: wf_activities wfa,

10147: -- Select all lookup codes for an activities result type
10148: cursor result_codes is
10149: select wfl.lookup_code result_code
10150: from wf_lookups wfl,
10151: wf_activities wfa,
10152: wf_process_activities wfpa,
10153: wf_items wfi
10154: where wfl.lookup_type = wfa.result_type
10155: and wfa.name = wfpa.activity_name