APPS.POS_TOTALS_PO_SV dependencies on PO_HEADERS_ARCHIVE_ALL

Line 19: from po_headers_archive_all

15: /* Always calculate the total from archive tables. */
16:
17: select type_lookup_code, revision_num
18: into l_document_type, l_revision_num
19: from po_headers_archive_all
20: where po_header_id = X_header_id and latest_external_flag = 'Y';
21:
22: X_po_total := POS_TOTALS_PO_SV.get_po_archive_total(X_header_id, l_revision_num,l_document_type);
23: RETURN (X_po_total);

Line 51: po_headers_archive_all pha

47: INTO x_min_unit,
48: x_precision,
49: x_global_agree_flag
50: FROM fnd_currencies fc,
51: po_headers_archive_all pha
52: WHERE pha.po_header_id = X_header_id
53: AND pha.revision_num = X_revision_num
54: AND fc.currency_code = pha.currency_code;
55:

Line 186: po_headers_archive_all pha

182: fc.precision
183: INTO x_min_unit,
184: x_precision
185: FROM fnd_currencies fc,
186: po_headers_archive_all pha
187: WHERE pha.po_header_id = X_header_id
188: AND pha.revision_num = X_revision_num
189: AND fc.currency_code = pha.currency_code;
190:

Line 225: FROM po_headers_archive_all

221:
222: else
223: SELECT BLANKET_TOTAL_AMOUNT
224: INTO X_po_total
225: FROM po_headers_archive_all
226: WHERE revision_num = X_revision_num
227: AND po_header_id = X_header_id;
228: end if;
229:

Line 263: po_headers_archive_all pha,

259: fc.precision
260: INTO x_min_unit,
261: x_precision
262: FROM fnd_currencies fc,
263: po_headers_archive_all pha,
264: po_releases_archive_all pra
265: WHERE pha.po_header_id = pra.po_header_id
266: AND pha.LATEST_EXTERNAL_FLAG = 'Y'
267: AND pra.po_release_id = X_release_id

Line 347: po_headers_archive_all poh

343: fc.precision
344: INTO x_min_unit,
345: x_precision
346: FROM fnd_currencies fc,
347: po_headers_archive_all poh
348: WHERE poh.revision_num = x_revision_num
349: AND poh.po_header_id = x_po_header_id
350: AND fc.currency_code = poh.currency_code;
351:

Line 409: po_headers_archive_all poh

405: fc.precision
406: INTO x_min_unit,
407: x_precision
408: FROM fnd_currencies fc,
409: po_headers_archive_all poh
410: WHERE poh.revision_num = x_revision_num
411: AND poh.po_header_id = x_po_header_id
412: AND fc.currency_code = poh.currency_code;
413:

Line 712: po_headers_archive_all pha

708: fc.precision
709: INTO x_min_unit,
710: x_precision
711: FROM fnd_currencies fc,
712: po_headers_archive_all pha
713: WHERE fc.currency_code = pha.currency_code
714: AND pha.po_header_id = p_po_header_id
715: AND pha.latest_external_flag='Y';
716:

Line 800: po_headers_archive_all pha

796: fc.precision
797: INTO x_min_unit,
798: x_precision
799: FROM fnd_currencies fc,
800: po_headers_archive_all pha
801: WHERE fc.currency_code = pha.currency_code
802: AND pha.po_header_id = p_po_header_id
803: AND pha.latest_external_flag='Y';
804: