APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 242: FROM po_lines_archive_all pol

238: nvl2(l_mau
239: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
240: , round((pol.quantity*pol.unit_price),l_precision)) )) -- Bug# 5378134
241: INTO l_return_val
242: FROM po_lines_archive_all pol
243: WHERE pol.po_header_id = p_doc_level_id
244: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
245: OR (p_doc_revision_num IS NOT NULL
246: AND POL.revision_num =

Line 248: FROM po_lines_archive_all pol2

244: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
245: OR (p_doc_revision_num IS NOT NULL
246: AND POL.revision_num =
247: (SELECT max(POL2.revision_num)
248: FROM po_lines_archive_all pol2
249: WHERE pol2.po_line_id = pol.po_line_id
250: AND pol2.revision_num <= p_doc_revision_num)
251: )
252: )

Line 292: FROM po_lines_archive_all pol

288: nvl2(l_mau
289: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
290: , round((pol.quantity*pol.unit_price),l_precision)) ) -- Bug# 5378134
291: INTO l_return_val
292: FROM po_lines_archive_all pol
293: WHERE pol.po_line_id = p_doc_level_id
294: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
295: OR (p_doc_revision_num IS NOT NULL
296: AND POL.revision_num =

Line 298: FROM po_lines_archive_all pol2

294: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
295: OR (p_doc_revision_num IS NOT NULL
296: AND POL.revision_num =
297: (SELECT max(POL2.revision_num)
298: FROM po_lines_archive_all pol2
299: WHERE pol2.po_line_id = pol.po_line_id
300: AND pol2.revision_num <= p_doc_revision_num)
301: )
302: )

Line 4397: FROM po_lines_archive_all pol

4393: nvl2(l_mau
4394: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4395: , round((pol.quantity*pol.unit_price),l_precision)) ))
4396: INTO l_return_val
4397: FROM po_lines_archive_all pol
4398: WHERE pol.po_header_id = p_doc_level_id
4399: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
4400: OR (p_doc_revision_num IS NOT NULL
4401: AND POL.revision_num =

Line 4403: FROM po_lines_archive_all pol2

4399: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
4400: OR (p_doc_revision_num IS NOT NULL
4401: AND POL.revision_num =
4402: (SELECT max(POL2.revision_num)
4403: FROM po_lines_archive_all pol2
4404: WHERE pol2.po_line_id = pol.po_line_id
4405: AND pol2.revision_num <= p_doc_revision_num)
4406: )
4407: )

Line 4449: FROM po_lines_archive_all pol

4445: nvl2(l_mau
4446: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4447: , round((pol.quantity*pol.unit_price),l_precision)) )
4448: INTO l_return_val
4449: FROM po_lines_archive_all pol
4450: WHERE pol.po_line_id = p_doc_level_id
4451: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
4452: OR (p_doc_revision_num IS NOT NULL
4453: AND POL.revision_num =

Line 4455: FROM po_lines_archive_all pol2

4451: AND ( (p_doc_revision_num IS NULL and pol.latest_external_flag = 'Y')
4452: OR (p_doc_revision_num IS NOT NULL
4453: AND POL.revision_num =
4454: (SELECT max(POL2.revision_num)
4455: FROM po_lines_archive_all pol2
4456: WHERE pol2.po_line_id = pol.po_line_id
4457: AND pol2.revision_num <= p_doc_revision_num)
4458: )
4459: )

Line 4582: FROM po_lines_archive_all pol

4578: nvl2(l_mau
4579: , round(pol.quantity*pol.unit_price/l_mau) * l_mau
4580: , round((pol.quantity*pol.unit_price),l_precision)) ))
4581: INTO l_return_val
4582: FROM po_lines_archive_all pol
4583: WHERE pol.po_header_id = p_doc_id
4584: AND pol.latest_external_flag = 'Y'
4585: AND pol.clm_exhibit_name = p_exhibit_name;
4586: