DBA Data[Home] [Help]

APPS.OE_RMA_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 473: ,WF_ITEM_ACTIVITY_STATUSES WIAS

469:
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'

Line 564: ,WF_ITEM_ACTIVITY_STATUSES WIAS

560:
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'