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 508: FROM po_lines_draft_all

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