DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_LINES_DRAFT_ALL

Line 263: FROM po_lines_draft_all draft_lines

259: SELECT l_key,
260: p_po_header_id_tbl(i),
261: v.max_line_num
262: FROM (SELECT max(line_num) AS max_line_num
263: FROM po_lines_draft_all draft_lines
264: WHERE draft_id = p_draft_id_tbl(i)
265: AND po_header_id = p_po_header_id_tbl(i)) v
266: WHERE v.max_line_num IS NOT NULL;
267:

Line 506: FROM po_lines_draft_all

502: FORALL i IN 1..l_index_tbl.COUNT
503: INSERT INTO po_session_gt(key, num1)
504: SELECT l_key,
505: l_index_tbl(i)
506: FROM po_lines_draft_all
507: WHERE po_header_id = p_po_header_id_tbl(i)
508: AND draft_id = p_draft_id_tbl(i)
509: AND line_num = p_line_num_tbl(i);
510: