DBA Data[Home] [Help]

APPS.POS_TOTALS_PO_SV dependencies on PO_RELEASES_ARCHIVE_ALL

Line 243: po_releases_archive_all pra

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
247: AND pra.revision_num = X_revision_num

Line 377: PO_RELEASES_ARCHIVE_ALL POR

373: INTO x_min_unit,
374: x_precision
375: FROM PO_HEADERS_ALL POH,
376: FND_CURRENCIES FC,
377: PO_RELEASES_ARCHIVE_ALL POR
378: WHERE POR.po_release_id = x_po_release_id
379: AND por.revision_num = x_revision_num
380: AND POH.po_header_id = POR.po_header_id
381: AND FC.CURRENCY_CODE = POH.CURRENCY_CODE;

Line 656: from po_releases_archive_all

652: BEGIN
653:
654: select revision_num
655: into l_revision_num
656: from po_releases_archive_all
657: where po_release_id = X_release_id
658: and latest_external_flag = 'Y';
659:
660: X_release_total := get_release_archive_total