APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LINES_MERGE_V

Line 226: FROM po_lines_merge_v pol -- Changed from po_lines_all

222: nvl2(l_mau
223: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
224: , round((pol.quantity*pol.unit_price),l_precision)) )) -- Bug# 5378134
225: INTO l_return_val
226: FROM po_lines_merge_v pol -- Changed from po_lines_all
227: WHERE pol.po_header_id = p_doc_level_id
228: AND pol.draft_id = p_draft_id;
229:
230: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 277: FROM po_lines_merge_v pol -- Changed from po_lines_all

273: nvl2(l_mau
274: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
275: , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
276: INTO l_return_val
277: FROM po_lines_merge_v pol -- Changed from po_lines_all
278: WHERE pol.po_line_id = p_doc_level_id
279: AND pol.draft_id = p_draft_id;
280:
281: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 2275: FROM po_lines_merge_v pol -- Changed from po_lines_all

2271: d_position := 10;
2272:
2273: SELECT pol.po_header_id
2274: INTO l_header_id
2275: FROM po_lines_merge_v pol -- Changed from po_lines_all
2276: WHERE pol.po_line_id = p_line_id
2277: AND pol.draft_id = p_draft_id;
2278:
2279: d_position := 20;

Line 2316: FROM po_lines_merge_v pol -- Changed from po_lines_all

2312: d_position := 40;
2313:
2314: SELECT nvl(pol.quantity, 0)
2315: INTO l_return_val
2316: FROM po_lines_merge_v pol -- Changed from po_lines_all
2317: WHERE pol.po_line_id = p_line_id
2318: AND pol.draft_id = p_draft_id;
2319:
2320: END IF;

Line 2743: FROM po_lines_merge_v pol

2739:
2740: d_position := 30;
2741: SELECT Min(pol.po_header_id)
2742: INTO l_header_id
2743: FROM po_lines_merge_v pol
2744: WHERE pol.po_line_id = p_doc_level_id;
2745:
2746: ELSIF p_doc_level = g_doc_level_SHIPMENT THEN
2747:

Line 4379: FROM po_lines_merge_v pol -- Changed from po_lines_all

4375: nvl2(l_mau
4376: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4377: , round((pol.quantity*pol.unit_price),l_precision)) ))
4378: INTO l_return_val
4379: FROM po_lines_merge_v pol -- Changed from po_lines_all
4380: WHERE pol.po_header_id = p_doc_level_id
4381: AND pol.draft_id = p_draft_id
4382: AND (NVL(pol.clm_option_indicator,'N') <> 'O'
4383: OR pol.clm_exercised_flag = 'Y'); --

Line 4432: FROM po_lines_merge_v pol -- Changed from po_lines_all

4428: nvl2(l_mau
4429: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4430: , round((pol.quantity*pol.unit_price),l_precision)) )
4431: INTO l_return_val
4432: FROM po_lines_merge_v pol -- Changed from po_lines_all
4433: WHERE pol.po_line_id = p_doc_level_id
4434: AND pol.draft_id = p_draft_id
4435: AND (NVL(pol.clm_option_indicator,'N') <> 'O'
4436: OR pol.clm_exercised_flag = 'Y'); --

Line 4564: FROM po_lines_merge_v pol

4560: nvl2(l_mau
4561: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4562: , round((pol.quantity*pol.unit_price),l_precision)) ))
4563: INTO l_return_val
4564: FROM po_lines_merge_v pol
4565: WHERE pol.po_header_id = p_doc_id
4566: AND pol.draft_id = p_draft_id
4567: AND pol.clm_exhibit_name = p_exhibit_name;
4568: