APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINES_MERGE_V

Line 183: FROM po_lines_merge_v pol

179:
180: -- CLM Apprvl
181: CURSOR line_closed_mod(lineid NUMBER, draftId NUMBER) is
182: SELECT nvl(pol.closed_code, 'OPEN')
183: FROM po_lines_merge_v pol
184: WHERE pol.po_line_id = lineid
185: AND pol.draft_id = draftId;
186:
187:

Line 2617: FROM po_lines_merge_v

2613:
2614: -- Changed the above line to handle the CPA case also
2615: SELECT po_header_id, from_line_id, nvl(from_header_id, contract_id), amount, quantity, matching_basis
2616: INTO l_po_header_id, l_idv_line_id, l_idv_header_id, l_line_amount, l_line_quantity, l_line_type
2617: FROM po_lines_merge_v
2618: WHERE po_line_id = p_po_line_id
2619: AND draft_id = p_draft_id;
2620:
2621: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/

Line 2835: SELECT po_line_id FROM po_lines_merge_v

2831: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
2832: d_progress NUMBER := 0;
2833:
2834: CURSOR c_get_po_line_dtls(p_po_header_id NUMBER) IS
2835: SELECT po_line_id FROM po_lines_merge_v
2836: WHERE po_header_id = p_po_header_id
2837: AND draft_id = p_draft_id
2838: AND (from_header_id IS NOT NULL or contract_id is not null);
2839: --AND from_line_id IS NOT null;