APPS.POS_TOTALS_PO_SV dependencies on PO_HEADERS_ARCHIVE_ALL

Line 20: from po_headers_archive_all

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

Line 52: po_headers_archive_all pha

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

Line 165: po_headers_archive_all pha

161: fc.precision
162: INTO x_min_unit,
163: x_precision
164: FROM fnd_currencies fc,
165: po_headers_archive_all pha
166: WHERE pha.po_header_id = X_header_id
167: AND pha.revision_num = X_revision_num
168: AND fc.currency_code = pha.currency_code;
169:

Line 204: FROM po_headers_archive_all

200:
201: else
202: SELECT BLANKET_TOTAL_AMOUNT
203: INTO X_po_total
204: FROM po_headers_archive_all
205: WHERE revision_num = X_revision_num
206: AND po_header_id = X_header_id;
207: end if;
208:

Line 242: po_headers_archive_all pha,

238: fc.precision
239: INTO x_min_unit,
240: x_precision
241: FROM fnd_currencies fc,
242: po_headers_archive_all pha,
243: po_releases_archive_all pra
244: WHERE pha.po_header_id = pra.po_header_id
245: AND pha.LATEST_EXTERNAL_FLAG = 'Y'
246: AND pra.po_release_id = X_release_id

Line 326: po_headers_archive_all poh

322: fc.precision
323: INTO x_min_unit,
324: x_precision
325: FROM fnd_currencies fc,
326: po_headers_archive_all poh
327: WHERE poh.revision_num = x_revision_num
328: AND poh.po_header_id = x_po_header_id
329: AND fc.currency_code = poh.currency_code;
330:

Line 388: po_headers_archive_all poh

384: fc.precision
385: INTO x_min_unit,
386: x_precision
387: FROM fnd_currencies fc,
388: po_headers_archive_all poh
389: WHERE poh.revision_num = x_revision_num
390: AND poh.po_header_id = x_po_header_id
391: AND fc.currency_code = poh.currency_code;
392:

Line 691: po_headers_archive_all pha

687: fc.precision
688: INTO x_min_unit,
689: x_precision
690: FROM fnd_currencies fc,
691: po_headers_archive_all pha
692: WHERE fc.currency_code = pha.currency_code
693: AND pha.po_header_id = p_po_header_id
694: AND pha.latest_external_flag='Y';
695:

Line 813: po_headers_archive_all pha

809: fc.precision
810: INTO x_min_unit,
811: x_precision
812: FROM fnd_currencies fc,
813: po_headers_archive_all pha
814: WHERE fc.currency_code = pha.currency_code
815: AND pha.po_header_id = p_po_header_id
816: AND pha.latest_external_flag='Y';
817: