DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1631: FROM WF_ITEM_ACTIVITY_STATUSES wias, WF_PROCESS_ACTIVITIES wpa

1627: END IF;
1628:
1629: SELECT wias.ACTIVITY_STATUS, wias.ACTIVITY_RESULT_CODE, wias.PROCESS_ACTIVITY
1630: INTO x_activity_status_code, x_activity_result, x_activity_id
1631: FROM WF_ITEM_ACTIVITY_STATUSES wias, WF_PROCESS_ACTIVITIES wpa
1632: WHERE wias.ITEM_KEY = p_itemkey
1633: AND wias.ITEM_TYPE = p_itemtype
1634: AND wpa.ACTIVITY_NAME = p_activity_name
1635: AND wias.PROCESS_ACTIVITY = wpa.INSTANCE_ID;