DBA Data[Home] [Help]

APPS.OE_ERROR_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 1825: WF_ITEM_ATTRIBUTE_VALUES WAT,

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
1828: AND IAS.ITEM_KEY = I.ITEM_KEY
1829: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 1851: WF_ITEM_ATTRIBUTE_VALUES WAT,

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
1854: AND IAS.ITEM_KEY = I.ITEM_KEY
1855: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 1876: WF_ITEM_ATTRIBUTE_VALUES WAT,

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
1879: AND IAS.ITEM_KEY = I.ITEM_KEY
1880: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 1903: WF_ITEM_ATTRIBUTE_VALUES WAT,

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
1906: AND IAS.ITEM_KEY = I.ITEM_KEY
1907: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 1929: WF_ITEM_ATTRIBUTE_VALUES WAT,

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
1932: AND IAS.ITEM_KEY = I.ITEM_KEY
1933: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 1956: WF_ITEM_ATTRIBUTE_VALUES WAT,

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
1959: AND IAS.ITEM_KEY = I.ITEM_KEY
1960: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID