DBA Data[Home] [Help]

APPS.POS_TOTALS_PO_SV dependencies on PO_RELEASES_ARCHIVE_ALL

Line 264: po_releases_archive_all pra

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

Line 398: PO_RELEASES_ARCHIVE_ALL POR

394: INTO x_min_unit,
395: x_precision
396: FROM PO_HEADERS_ALL POH,
397: FND_CURRENCIES FC,
398: PO_RELEASES_ARCHIVE_ALL POR
399: WHERE POR.po_release_id = x_po_release_id
400: AND por.revision_num = x_revision_num
401: AND POH.po_header_id = POR.po_header_id
402: AND FC.CURRENCY_CODE = POH.CURRENCY_CODE;

Line 677: from po_releases_archive_all

673: BEGIN
674:
675: select revision_num
676: into l_revision_num
677: from po_releases_archive_all
678: where po_release_id = X_release_id
679: and latest_external_flag = 'Y';
680:
681: X_release_total := get_release_archive_total