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

Line 2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,

2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:
2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2163: WF_ACTIVITIES WA
2164:
2165: where WPA.INSTANCE_ID = actid
2166: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE

Line 2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,

2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:
2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2332: WF_ACTIVITIES WA
2333:
2334: where WPA.INSTANCE_ID = actid
2335: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE

Line 2408: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2407:
2408: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
2409:
2410: where WPA.INSTANCE_ID = actid
2411: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
2412: and WA.NAME = WPA.ACTIVITY_NAME

Line 3074: from WF_PROCESS_ACTIVITIES WPA

3070: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
3071: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
3072: WPA.START_END, WPA.DEFAULT_RESULT
3073: into WF_CACHE.ProcessActivities(actid)
3074: from WF_PROCESS_ACTIVITIES WPA
3075: where WPA.INSTANCE_ID = GetActivityLabel.actid;
3076:
3077: end if;
3078:

Line 3662: WF_PROCESS_ACTIVITIES WPAP,

3658: INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */
3659: WIASP.ROWID ROW_ID
3660: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3661: WF_ITEMS WI,
3662: WF_PROCESS_ACTIVITIES WPAP,
3663: WF_ACTIVITIES WAP
3664: where WIASP.ITEM_TYPE = itemtype
3665: and WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3666: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE

Line 3677: WF_PROCESS_ACTIVITIES WPAC

3673: and WIASP.ACTIVITY_STATUS = 'ACTIVE' --use literal to force index
3674: and not exists
3675: (select null
3676: from WF_ITEM_ACTIVITY_STATUSES WIASC,
3677: WF_PROCESS_ACTIVITIES WPAC
3678: where WAP.ITEM_TYPE = WPAC.PROCESS_ITEM_TYPE
3679: and WAP.NAME = WPAC.PROCESS_NAME
3680: and WAP.VERSION = WPAC.PROCESS_VERSION
3681: and WPAC.INSTANCE_ID = WIASC.PROCESS_ACTIVITY

Line 3693: WF_PROCESS_ACTIVITIES WPAP,

3689: INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */
3690: WIASP.ROWID ROW_ID
3691: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3692: WF_ITEMS WI,
3693: WF_PROCESS_ACTIVITIES WPAP,
3694: WF_ACTIVITIES WAP
3695: where WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3696: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3697: and WPAP.ACTIVITY_NAME = WAP.NAME

Line 3707: WF_PROCESS_ACTIVITIES WPAC

3703: and WIASP.ACTIVITY_STATUS = 'ACTIVE' --use literal to force index
3704: and not exists
3705: (select null
3706: from WF_ITEM_ACTIVITY_STATUSES WIASC,
3707: WF_PROCESS_ACTIVITIES WPAC
3708: where WAP.ITEM_TYPE = WPAC.PROCESS_ITEM_TYPE
3709: and WAP.NAME = WPAC.PROCESS_NAME
3710: and WAP.VERSION = WPAC.PROCESS_VERSION
3711: and WPAC.INSTANCE_ID = WIASC.PROCESS_ACTIVITY

Line 3756: WF_PROCESS_ACTIVITIES WPAP,

3752: select
3753: WIASP.ITEM_TYPE, WIASP.ITEM_KEY, WIASP.PROCESS_ACTIVITY
3754: into l_itemtype, l_itemkey, l_actid
3755: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3756: WF_PROCESS_ACTIVITIES WPAP,
3757: WF_ACTIVITIES WAP,
3758: WF_ITEMS WI
3759: where WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3760: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE

Line 3771: WF_PROCESS_ACTIVITIES WPAC

3767: and WIASP.ACTIVITY_STATUS = 'ACTIVE' --use literal to force index
3768: and not exists
3769: (select null
3770: from WF_ITEM_ACTIVITY_STATUSES WIASC,
3771: WF_PROCESS_ACTIVITIES WPAC
3772: where WAP.ITEM_TYPE = WPAC.PROCESS_ITEM_TYPE
3773: and WAP.NAME = WPAC.PROCESS_NAME
3774: and WAP.VERSION = WPAC.PROCESS_VERSION
3775: and WPAC.INSTANCE_ID = WIASC.PROCESS_ACTIVITY

Line 5387: from wf_process_activities pa,

5383: and item_key = itemkey
5384: and activity_status = 'ACTIVE'
5385: and activity_status = wf_engine.eng_active
5386: and exists (select 'its a function, not subprocess'
5387: from wf_process_activities pa,
5388: wf_activities ac
5389: where pa.activity_name = ac.name
5390: and pa.activity_item_type = ac.item_type
5391: and pa.activity_item_type = ias.item_type

Line 5751: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

5747: -- Look up activity instance label
5748: begin
5749: select WPA.PROCESS_NAME, WPA.INSTANCE_LABEL
5750: into process, label
5751: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
5752: where WIAS.ITEM_TYPE = itemtype
5753: and WIAS.ITEM_KEY = itemkey
5754: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
5755: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 6222: WF_PROCESS_ACTIVITIES pa

6218: select ias.ITEM_KEY,
6219: pa.INSTANCE_LABEL activity,
6220: pa.INSTANCE_ID actid
6221: from WF_ITEM_ACTIVITY_STATUSES ias,
6222: WF_PROCESS_ACTIVITIES pa
6223: where ias.ITEM_TYPE = x_itemtype
6224: and (x_itemkey is null or ias.ITEM_KEY = x_itemkey)
6225: and (x_activity is null or pa.INSTANCE_LABEL = x_activity)
6226: and ias.PROCESS_ACTIVITY = pa.INSTANCE_ID

Line 6396: wf_process_activities pa,

6392: ias.notification_id NID,
6393: ntf.status,
6394: ias.performed_by
6395: from wf_item_activity_statuses ias,
6396: wf_process_activities pa,
6397: wf_activities ac,
6398: wf_activities ap,
6399: wf_items i,
6400: wf_notifications ntf

Line 6562: from WF_PROCESS_ACTIVITIES WPA,

6558: n number;
6559:
6560: cursor actcur(ver number) is
6561: select WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME
6562: from WF_PROCESS_ACTIVITIES WPA,
6563: WF_ACTIVITIES WA
6564: where WPA.PROCESS_ITEM_TYPE = p_process_item_type
6565: and WPA.PROCESS_NAME = p_process_name
6566: and WPA.PROCESS_VERSION = ver

Line 6598: from WF_PROCESS_ACTIVITIES

6594: end;
6595:
6596: -- then check to see if such activity exist
6597: select count(1) into n
6598: from WF_PROCESS_ACTIVITIES
6599: where PROCESS_ITEM_TYPE = p_process_item_type
6600: and PROCESS_NAME = p_process_name
6601: and PROCESS_VERSION = m_version
6602: and ACTIVITY_ITEM_TYPE = nvl(p_activity_item_type, p_process_item_type)

Line 6665: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,

6661:
6662: -- Blocked activities waiting for event (if existing process)
6663: cursor evtacts is
6664: SELECT WIAS.PROCESS_ACTIVITY actid
6665: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,
6666: WF_ACTIVITIES WA
6667: WHERE WIAS.ITEM_TYPE = event.itemtype
6668: AND WIAS.ITEM_KEY = event.itemkey
6669: AND WIAS.ACTIVITY_STATUS = 'NOTIFIED'

Line 6905: WF_PROCESS_ACTIVITIES WPA,

6901: -- Blocked activities waiting for event (if existing process)
6902: cursor evtacts is
6903: SELECT /*+ LEADING(WA) */ WIAS.ITEM_TYPE, WIAS.ITEM_KEY, WIAS.PROCESS_ACTIVITY ACTID
6904: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
6905: WF_PROCESS_ACTIVITIES WPA,
6906: (
6907: SELECT /*+ NO_MERGE */ WA.*
6908: FROM WF_ACTIVITIES WA
6909: where WA.TYPE = 'EVENT'

Line 7238: wf_process_activities wpa

7234: SELECT wias.item_key,
7235: wpa.process_name,
7236: wpa.instance_label activity
7237: FROM wf_item_activity_statuses wias,
7238: wf_process_activities wpa
7239: WHERE wias.item_type = x_item_type
7240: AND (x_item_key IS NULL OR wias.item_key = x_item_key)
7241: AND (x_process IS NULL OR wpa.process_name = x_process)
7242: AND (x_activity IS NULL OR wpa.instance_label = x_activity)