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.MRP_EXP_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1930: FROM wf_item_activity_statuses

1926: UPDATE wf_notifications
1927: SET end_date = SYSDATE - 450
1928: WHERE group_id IN
1929: (SELECT notification_id
1930: FROM wf_item_activity_statuses
1931: WHERE item_type = l_item_type
1932: AND item_key = l_item_key
1933: UNION
1934: SELECT notification_id

Line 1935: FROM wf_item_activity_statuses_h

1931: WHERE item_type = l_item_type
1932: AND item_key = l_item_key
1933: UNION
1934: SELECT notification_id
1935: FROM wf_item_activity_statuses_h
1936: WHERE item_type = l_item_type
1937: AND item_key = l_item_key);
1938:
1939: UPDATE wf_items

Line 1944: UPDATE wf_item_activity_statuses

1940: SET end_date = SYSDATE - 450
1941: WHERE item_type = l_item_type
1942: AND item_key = l_item_key ;
1943:
1944: UPDATE wf_item_activity_statuses
1945: SET end_date = SYSDATE - 450
1946: WHERE item_type = l_item_type
1947: AND item_key = l_item_key;
1948:

Line 1949: UPDATE wf_item_activity_statuses_h

1945: SET end_date = SYSDATE - 450
1946: WHERE item_type = l_item_type
1947: AND item_key = l_item_key;
1948:
1949: UPDATE wf_item_activity_statuses_h
1950: SET end_date = SYSDATE - 450
1951: WHERE item_type = l_item_type
1952: AND item_key = l_item_key;
1953:

Line 1988: wf_item_activity_statuses wias

1984: CURSOR CANCEL_NOTIFICATIONS_C( p_item_type in varchar2,
1985: p_item_key in varchar2) IS
1986: SELECT wn.notification_id
1987: FROM wf_notifications wn,
1988: wf_item_activity_statuses wias
1989: WHERE wn.status = 'OPEN'
1990: AND wn.notification_id = wias.notification_id
1991: AND wias.item_key = p_item_key
1992: AND wias.item_type = p_item_type;

Line 2020: -- but not in WF_ITEM_ACTIVITY_STATUSES. If so, error.

2016: FETCH DELETE_ACTIVITIES_C INTO l_item_key;
2017: EXIT WHEN DELETE_ACTIVITIES_C%NOTFOUND OR DELETE_ACTIVITIES_C%NOTFOUND IS NULL;
2018:
2019: -- It might happen that WF process is defined in WF_ITEMS table
2020: -- but not in WF_ITEM_ACTIVITY_STATUSES. If so, error.
2021:
2022: -- SELECT count(*)
2023: -- INTO l_activity_count
2024: -- FROM wf_item_activity_statuses

Line 2024: -- FROM wf_item_activity_statuses

2020: -- but not in WF_ITEM_ACTIVITY_STATUSES. If so, error.
2021:
2022: -- SELECT count(*)
2023: -- INTO l_activity_count
2024: -- FROM wf_item_activity_statuses
2025: -- WHERE item_type = 'MRPEXPWF'
2026: -- AND item_key = l_item_key;
2027:
2028: -- if (l_activity_count > 0) then