DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_UTIL_PVT dependencies on PO_REQ_LINES_IN_POOL_SEC_V

Line 271: FROM po_req_lines_in_pool_sec_v pool

267: IF ( p_lock_records = 'Y' ) THEN
268:
269: SELECT pool.requisition_line_id
270: BULK COLLECT INTO x_req_line_id_in_pool_tbl
271: FROM po_req_lines_in_pool_sec_v pool
272: WHERE pool.requisition_line_id IN ( SELECT selected.index_num1
273: FROM po_session_gt selected
274: WHERE selected.key = l_key
275: )

Line 286: FROM po_req_lines_in_pool_sec_v pool

282: ELSE
283:
284: SELECT pool.requisition_line_id
285: BULK COLLECT INTO x_req_line_id_in_pool_tbl
286: FROM po_req_lines_in_pool_sec_v pool
287: WHERE pool.requisition_line_id IN ( SELECT selected.index_num1
288: FROM po_session_gt selected
289: WHERE selected.key = l_key
290: );