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.OE_HOLDS_WF dependencies on WF_PROCESS_ACTIVITIES

Line 133: WF_PROCESS_ACTIVITIES CHILD,

129:
130: SELECT PARENT.ACTIVITY_ITEM_TYPE, PARENT.ACTIVITY_NAME
131: INTO l_wf_item, l_wf_activity
132: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
133: WF_PROCESS_ACTIVITIES CHILD,
134: WF_PROCESS_ACTIVITIES PARENT
135: WHERE CHILD.INSTANCE_ID = actid
136: AND CHILD.PROCESS_ITEM_TYPE = PARENT.ACTIVITY_ITEM_TYPE
137: AND CHILD.PROCESS_NAME = PARENT.ACTIVITY_NAME

Line 134: WF_PROCESS_ACTIVITIES PARENT

130: SELECT PARENT.ACTIVITY_ITEM_TYPE, PARENT.ACTIVITY_NAME
131: INTO l_wf_item, l_wf_activity
132: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
133: WF_PROCESS_ACTIVITIES CHILD,
134: WF_PROCESS_ACTIVITIES PARENT
135: WHERE CHILD.INSTANCE_ID = actid
136: AND CHILD.PROCESS_ITEM_TYPE = PARENT.ACTIVITY_ITEM_TYPE
137: AND CHILD.PROCESS_NAME = PARENT.ACTIVITY_NAME
138: AND PARENT.INSTANCE_ID = IAS.PROCESS_ACTIVITY