APPS.PO_LINES_DRAFT_PVT dependencies on PO_LINES_MERGE_V

Line 624: -- collecting all line_num_display from po_lines_merge_v for the the given po_header_id.

620: END IF;
621:
622: -- Select Line Nums which have been added by other Modifications
623: --
624: -- collecting all line_num_display from po_lines_merge_v for the the given po_header_id.
625: -- this includes line_num_displa from base DOcument, Modification, PAR
626: SELECT DISTINCT line_num_display
627: BULK COLLECT INTO l_oth_line_num_arr
628: FROM po_lines_merge_v

Line 628: FROM po_lines_merge_v

624: -- collecting all line_num_display from po_lines_merge_v for the the given po_header_id.
625: -- this includes line_num_displa from base DOcument, Modification, PAR
626: SELECT DISTINCT line_num_display
627: BULK COLLECT INTO l_oth_line_num_arr
628: FROM po_lines_merge_v
629: WHERE po_header_id = p_po_header_id
630: AND group_line_id IS NULL
631: AND (status in ('DRAFT','REJECTED','IN PROCESS','PRE-APPROVED','COMPLETED',
632: 'WITHDRAWN','SUPPLIER SIGN') --

Line 702: -- po_lines_merge_v. If this is greater than p_max_slin_num use it,

698: PO_LOG.proc_begin(d_module);
699: END IF;
700:
701: -- Get the max line num display for the line id p_po_line_id from
702: -- po_lines_merge_v. If this is greater than p_max_slin_num use it,
703: -- else use p_max_slin_num itself.
704: SELECT max(line_num_display)
705: INTO l_max_slin_num
706: FROM po_lines_merge_v

Line 706: FROM po_lines_merge_v

702: -- po_lines_merge_v. If this is greater than p_max_slin_num use it,
703: -- else use p_max_slin_num itself.
704: SELECT max(line_num_display)
705: INTO l_max_slin_num
706: FROM po_lines_merge_v
707: WHERE group_line_id = p_po_line_id
708: AND NVL(status,'Base Document') <> 'WITHDRAWN'
709: AND draft_id <>p_draft_id
710: AND NVL(clm_info_flag, 'N') = p_info_flag;