DBA Data[Home] [Help]

APPS.ONT_OEXOEWFR_XMLP_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 290: WF_PROCESS_ACTIVITIES WPA

286: SELECT
287: WIAS.END_DATE
288: FROM
289: WF_ITEM_ACTIVITY_STATUSES WIAS,
290: WF_PROCESS_ACTIVITIES WPA
291: WHERE WIAS.ITEM_TYPE = 'OEOL'
292: AND WIAS.ITEM_KEY = TO_CHAR(LINE_ID)
293: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
294: AND WPA.ACTIVITY_NAME = 'INVOICE_INTERFACE';

Line 300: WF_PROCESS_ACTIVITIES WPA

296: SELECT
297: WIAS.END_DATE
298: FROM
299: WF_ITEM_ACTIVITY_STATUSES WIAS,
300: WF_PROCESS_ACTIVITIES WPA
301: WHERE WIAS.ITEM_TYPE = 'OEOH'
302: AND WIAS.ITEM_KEY = TO_CHAR(HEADER_ID1)
303: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
304: AND WPA.ACTIVITY_NAME = 'HEADER_INVOICE_INTERFACE';