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 8970: FROM WF_ITEMS wi

8966:
8967: SELECT wi.item_type wf_item_type
8968: , wi.item_key wf_item_key
8969: , wi.root_activity wf_process_name
8970: FROM WF_ITEMS wi
8971: WHERE wi.parent_item_type = p_route_item_type
8972: AND wi.parent_item_key = p_route_item_key
8973: AND wi.item_type IN ( Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
8974: , Eng_Workflow_Util.G_CHANGE_ROUTE_DOC_STEP_TYPE

Line 9612: wf_items wfi

9608: select wfl.lookup_code result_code
9609: from wf_lookups wfl,
9610: wf_activities wfa,
9611: wf_process_activities wfpa,
9612: wf_items wfi
9613: where wfl.lookup_type = wfa.result_type
9614: and wfa.name = wfpa.activity_name
9615: and wfi.begin_date >= wfa.begin_date
9616: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)

Line 10077: wf_items wfi

10073: select wfl.lookup_code result_code
10074: from wf_lookups wfl,
10075: wf_activities wfa,
10076: wf_process_activities wfpa,
10077: wf_items wfi
10078: where wfl.lookup_type = wfa.result_type
10079: and wfa.name = wfpa.activity_name
10080: and wfi.begin_date >= wfa.begin_date
10081: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)

Line 10465: , WF_ITEMS wi

10461: SELECT ecr.wf_item_type parent_item_type
10462: , ecr.wf_item_key parent_item_key
10463: FROM ENG_CHANGE_ROUTES ecr
10464: , ENG_ENGINEERING_CHANGES eec
10465: , WF_ITEMS wi
10466: WHERE wi.item_type = ecr.wf_item_type
10467: AND wi.item_key = ecr.wf_item_key
10468: AND wi.end_date IS NULL
10469: AND ecr.route_id = eec.route_id

Line 10536: FROM wf_items

10532:
10533: -- lock the parent item, so only one child can execute this at the time.
10534: SELECT item_key
10535: INTO dummy
10536: FROM wf_items
10537: WHERE item_type = l_parent_itemtype
10538: AND item_key = l_parent_itemkey
10539: FOR UPDATE ;
10540: