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_ERROR_WF dependencies on WF_ITEMS

Line 155: from wf_items

151: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152: IS
153: cursor err_flow IS
154: select ITEM_TYPE, ITEM_KEY, ROOT_ACTIVITY
155: from wf_items
156: where ITEM_TYPE IN ('OMERROR','WFERROR')
157: and PARENT_ITEM_TYPE = p_item_type
158: and PARENT_ITEM_KEY = p_item_key
159: and END_DATE is null;

Line 1823: WF_ITEMS I,

1819:
1820: CURSOR l_retry_cursor_1 IS
1821: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1822: FROM WF_PROCESS_ACTIVITIES PA,
1823: WF_ITEMS I,
1824: WF_ITEM_ACTIVITY_STATUSES IAS,
1825: WF_ITEM_ATTRIBUTE_VALUES WAT,
1826: WF_ACTIVITIES WA
1827: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE

Line 1849: WF_ITEMS I,

1845:
1846: CURSOR l_retry_cursor_2 IS
1847: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1848: FROM WF_PROCESS_ACTIVITIES PA,
1849: WF_ITEMS I,
1850: WF_ITEM_ACTIVITY_STATUSES IAS,
1851: WF_ITEM_ATTRIBUTE_VALUES WAT,
1852: WF_ACTIVITIES WA
1853: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE

Line 1874: WF_ITEMS I,

1870:
1871: CURSOR l_retry_cursor_3 IS
1872: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1873: FROM WF_PROCESS_ACTIVITIES PA,
1874: WF_ITEMS I,
1875: WF_ITEM_ACTIVITY_STATUSES IAS,
1876: WF_ITEM_ATTRIBUTE_VALUES WAT,
1877: WF_ACTIVITIES WA
1878: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE

Line 1901: WF_ITEMS I,

1897:
1898: CURSOR l_retry_cursor_4 IS
1899: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1900: FROM WF_PROCESS_ACTIVITIES PA,
1901: WF_ITEMS I,
1902: WF_ITEM_ACTIVITY_STATUSES IAS,
1903: WF_ITEM_ATTRIBUTE_VALUES WAT,
1904: WF_ACTIVITIES WA
1905: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE

Line 1927: WF_ITEMS I,

1923:
1924: CURSOR l_retry_cursor_5 IS
1925: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1926: FROM WF_PROCESS_ACTIVITIES PA,
1927: WF_ITEMS I,
1928: WF_ITEM_ACTIVITY_STATUSES IAS,
1929: WF_ITEM_ATTRIBUTE_VALUES WAT,
1930: WF_ACTIVITIES WA
1931: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE

Line 1954: WF_ITEMS I,

1950:
1951: CURSOR l_retry_cursor_6 IS
1952: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1953: FROM WF_PROCESS_ACTIVITIES PA,
1954: WF_ITEMS I,
1955: WF_ITEM_ACTIVITY_STATUSES IAS,
1956: WF_ITEM_ATTRIBUTE_VALUES WAT,
1957: WF_ACTIVITIES WA
1958: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE