DBA Data[Home] [Help]

APPS.POR_RCV_ORD_SV dependencies on WF_ITEMS

Line 2010: WF_ITEMS WI,

2006: --Bug 4999072 Changed the query to reduce the memory usage
2007: SELECT WIAS.ACTIVITY_STATUS
2008: INTO x_act_status
2009: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
2010: WF_ITEMS WI,
2011: WF_PROCESS_ACTIVITIES PA
2012: WHERE WIAS.ITEM_TYPE = wf_item_type
2013: AND WIAS.ITEM_KEY = wf_item_key
2014: AND WIAS.ITEM_TYPE = WI.ITEM_TYPE