DBA Data[Home] [Help]

APPS.OE_RMA_WF dependencies on WF_PROCESS_ACTIVITIES

Line 474: ,WF_PROCESS_ACTIVITIES WPA

470: CURSOR return_lines IS
471: SELECT line_id,wias.item_type,wias.item_key
472: FROM oe_order_lines l
473: ,WF_ITEM_ACTIVITY_STATUSES WIAS
474: ,WF_PROCESS_ACTIVITIES WPA
475: WHERE l.header_id = To_Number(itemkey)
476: AND l.line_category_code = 'RETURN'
477: AND l.open_flag = 'Y'
478: AND WIAS.item_type = 'OEOL'

Line 565: ,WF_PROCESS_ACTIVITIES WPA

561: CURSOR return_lines IS
562: SELECT line_id,wias.item_type,wias.item_key
563: FROM oe_order_lines l
564: ,WF_ITEM_ACTIVITY_STATUSES WIAS
565: ,WF_PROCESS_ACTIVITIES WPA
566: WHERE l.header_id = To_Number(itemkey)
567: AND l.line_category_code = 'RETURN'
568: AND l.open_flag = 'Y'
569: AND WIAS.item_type = 'OEOL'