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_MAINTENANCE dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 105: from WF_ITEM_ACTIVITY_STATUSES_H

101: and WIAS.ASSIGNED_USER = l_oldname;
102:
103: cursor cItemActivityStatuses_H (l_oldname varchar2) is
104: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
105: from WF_ITEM_ACTIVITY_STATUSES_H
106: where ASSIGNED_USER = l_oldname;
107:
108: cursor cItemActivityStatuses_H2 (l_oldname varchar2) is
109: select WIASH.ITEM_TYPE, WIASH.ITEM_KEY, WIASH.PROCESS_ACTIVITY

Line 110: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

106: where ASSIGNED_USER = l_oldname;
107:
108: cursor cItemActivityStatuses_H2 (l_oldname varchar2) is
109: select WIASH.ITEM_TYPE, WIASH.ITEM_KEY, WIASH.PROCESS_ACTIVITY
110: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
111: where WIASH.ITEM_TYPE = wi.item_type
112: and WIASH.ITEM_KEY = wi.item_key
113: and WI.END_DATE IS NULL
114: and WIASH.ASSIGNED_USER = l_oldname;

Line 142: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

138: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
139: and WIAS.ITEM_KEY = WI.ITEM_KEY
140: and WI.END_DATE IS NULL)
141: or exists (select '1'
142: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
143: where WIASH.NOTIFICATION_ID = WN.NOTIFICATION_ID
144: and WIASH.NOTIFICATION_ID is not null
145: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
146: and WIASH.ITEM_KEY = WI.ITEM_KEY

Line 193: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

189: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
190: and WIAS.ITEM_KEY = WI.ITEM_KEY
191: and WI.END_DATE IS NULL)
192: or exists (select '1'
193: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
194: where WIASH.NOTIFICATION_ID = WC.NOTIFICATION_ID
195: and WIASH.NOTIFICATION_ID is not null
196: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
197: and WIASH.ITEM_KEY = WI.ITEM_KEY

Line 335: update WF_ITEM_ACTIVITY_STATUSES_H

331: exit;
332: end if;
333:
334: forall i in itemActTbl.first..itemActTbl.last
335: update WF_ITEM_ACTIVITY_STATUSES_H
336: set ASSIGNED_USER = l_newname
337: where ITEM_TYPE = itemActTbl(i).item_type
338: and ITEM_KEY = itemActTbl(i).item_key
339: and PROCESS_ACTIVITY = itemActTbl(i).process_activity;

Line 463: update WF_ITEM_ACTIVITY_STATUSES_H

459: exit;
460: end if;
461:
462: forall i in itemActTbl.first..itemActTbl.last
463: update WF_ITEM_ACTIVITY_STATUSES_H
464: set ASSIGNED_USER = l_newname
465: where ITEM_TYPE = itemActTbl(i).item_type
466: and ITEM_KEY = itemActTbl(i).item_key
467: and PROCESS_ACTIVITY = itemActTbl(i).process_activity;

Line 2040: -- Determine rows to change in WF_ITEM_ACTIVITY_STATUSES_H

2036: end if;
2037: l_wfcount_tab.TABLE_NAME :='WF_ITEM_ACTIVITY_STATUSES';
2038: pipe ROW (l_wfcount_tab);
2039:
2040: -- Determine rows to change in WF_ITEM_ACTIVITY_STATUSES_H
2041: if (l_pvalue is null or l_pvalue = 'Y') then
2042: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2043: from WF_ITEM_ACTIVITY_STATUSES_H WIASH
2044: where ASSIGNED_USER = p_name;

Line 2043: from WF_ITEM_ACTIVITY_STATUSES_H WIASH

2039:
2040: -- Determine rows to change in WF_ITEM_ACTIVITY_STATUSES_H
2041: if (l_pvalue is null or l_pvalue = 'Y') then
2042: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2043: from WF_ITEM_ACTIVITY_STATUSES_H WIASH
2044: where ASSIGNED_USER = p_name;
2045: else
2046: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2047: from WF_ITEM_ACTIVITY_STATUSES_H WIASH

Line 2047: from WF_ITEM_ACTIVITY_STATUSES_H WIASH

2043: from WF_ITEM_ACTIVITY_STATUSES_H WIASH
2044: where ASSIGNED_USER = p_name;
2045: else
2046: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2047: from WF_ITEM_ACTIVITY_STATUSES_H WIASH
2048: where exists (select '1'
2049: from WF_ITEMS WI
2050: where WI.ITEM_TYPE=WIASH.ITEM_TYPE and
2051: WI.ITEM_KEY=WIASH.ITEM_KEY and

Line 2055: l_wfcount_tab.TABLE_NAME :='WF_ITEM_ACTIVITY_STATUSES_H';

2051: WI.ITEM_KEY=WIASH.ITEM_KEY and
2052: WI.END_DATE is null) and
2053: ASSIGNED_USER = p_name;
2054: end if;
2055: l_wfcount_tab.TABLE_NAME :='WF_ITEM_ACTIVITY_STATUSES_H';
2056: pipe ROW (l_wfcount_tab);
2057:
2058: -- Determine rows to change in WF_NOTIFICATIONS
2059: if (l_pvalue is null or l_pvalue = 'Y') then

Line 2077: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

2073: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
2074: and WIAS.ITEM_KEY = WI.ITEM_KEY
2075: and WI.END_DATE IS NULL)
2076: or exists (select '1'
2077: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
2078: where WIASH.NOTIFICATION_ID = WN.NOTIFICATION_ID
2079: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
2080: and WIASH.ITEM_KEY = WI.ITEM_KEY
2081: and WI.END_DATE IS NULL))

Line 2172: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

2168: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
2169: and WIAS.ITEM_KEY = WI.ITEM_KEY
2170: and WI.END_DATE IS NULL)
2171: or exists (select '1'
2172: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
2173: where WIASH.NOTIFICATION_ID = WC.NOTIFICATION_ID
2174: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
2175: and WIASH.ITEM_KEY = WI.ITEM_KEY
2176: and WI.END_DATE IS NULL));