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_ITEMS

Line 1892: from WF_ITEMS WI

1888: select WI.BEGIN_DATE
1889: , WI.ROOT_ACTIVITY
1890: into l_begin_date
1891: , l_process_name
1892: from WF_ITEMS WI
1893: where WI.ITEM_TYPE = p_item_type
1894: and WI.ITEM_KEY = p_item_key ;
1895:
1896:

Line 2679: FROM WF_ITEMS

2675:
2676: -- Fnd User's User Name
2677: SELECT owner_role
2678: INTO x_item_owner_role
2679: FROM WF_ITEMS
2680: WHERE item_type = p_item_type
2681: AND item_key = p_item_key ;
2682:
2683:

Line 8089: , WF_ITEMS wi

8085: SELECT wi.item_type
8086: , wi.item_key
8087: FROM ENG_ENGINEERING_CHANGES eec
8088: , ENG_CHANGE_ROUTES ecr
8089: , WF_ITEMS wi
8090: WHERE wi.end_date IS NULL
8091: AND wi.item_key = ecr.wf_item_key
8092: AND wi.item_type = ecr.wf_item_type
8093: AND ecr.status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS

Line 8105: , WF_ITEMS wi

8101: SELECT wi.item_type
8102: , wi.item_key
8103: FROM ENG_CHANGE_LINES ecl
8104: , ENG_CHANGE_ROUTES ecr
8105: , WF_ITEMS wi
8106: WHERE wi.end_date IS NULL
8107: AND wi.item_key = ecr.wf_item_key
8108: AND wi.item_type = ecr.wf_item_type
8109: AND ecr.status_code = Eng_Workflow_Util.G_RT_IN_PROGRESS

Line 9046: FROM WF_ITEMS wi

9042:
9043: SELECT wi.item_type wf_item_type
9044: , wi.item_key wf_item_key
9045: , wi.root_activity wf_process_name
9046: FROM WF_ITEMS wi
9047: WHERE wi.parent_item_type = p_route_item_type
9048: AND wi.parent_item_key = p_route_item_key
9049: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
9050: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE

Line 9688: wf_items wfi

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
9691: and wfi.begin_date >= wfa.begin_date
9692: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)

Line 10153: wf_items wfi

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
10156: and wfi.begin_date >= wfa.begin_date
10157: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)

Line 10541: , WF_ITEMS wi

10537: SELECT ecr.wf_item_type parent_item_type
10538: , ecr.wf_item_key parent_item_key
10539: FROM ENG_CHANGE_ROUTES ecr
10540: , ENG_ENGINEERING_CHANGES eec
10541: , WF_ITEMS wi
10542: WHERE wi.item_type = ecr.wf_item_type
10543: AND wi.item_key = ecr.wf_item_key
10544: AND wi.end_date IS NULL
10545: AND ecr.route_id = eec.route_id

Line 10612: FROM wf_items

10608:
10609: -- lock the parent item, so only one child can execute this at the time.
10610: SELECT item_key
10611: INTO dummy
10612: FROM wf_items
10613: WHERE item_type = l_parent_itemtype
10614: AND item_key = l_parent_itemkey
10615: FOR UPDATE ;
10616: