DBA Data[Home] [Help]

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 5274: SELECT item_key FROM wf_item_activity_statuses_v

5270:
5271:
5272: --Select the item keys of the work flow processes which are waiting for MOD_SYNC lock
5273: CURSOR waiting_process_wf_keys(l_draft_id IN Number) IS
5274: SELECT item_key FROM wf_item_activity_statuses_v
5275: WHERE user_key = (SELECT segment1 FROM po_headers_all
5276: WHERE po_header_id = (SELECT document_id
5277: FROM po_drafts
5278: WHERE draft_id = l_draft_id))