DBA Data[Home] [Help]

APPS.POS_TOTALS_PO_SV dependencies on PO_HEADERS_ALL

Line 146: from po_headers_all

142: if (X_doc_type in ('STANDARD')) then
143:
144: select org_id
145: into x_org_id
146: from po_headers_all
147: where po_header_id = x_header_id;
148:
149: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ;
150:

Line 375: FROM PO_HEADERS_ALL POH,

371: SELECT fc.minimum_accountable_unit,
372: fc.precision
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

Line 496: po_headers_all pha,

492: fc.precision
493: INTO x_min_unit,
494: x_precision
495: FROM fnd_currencies fc,
496: po_headers_all pha,
497: po_line_locations_archive_all poll
498: WHERE poll.line_location_id = x_po_line_location_id
499: AND poll.po_header_id = pha.po_header_id
500: AND fc.currency_code = pha.currency_code

Line 560: po_headers_all pha,

556: fc.precision
557: INTO x_min_unit,
558: x_precision
559: FROM fnd_currencies fc,
560: po_headers_all pha,
561: po_line_locations_archive_all poll
562: WHERE poll.line_location_id = p_po_line_location_id
563: AND poll.po_header_id = pha.po_header_id
564: AND fc.currency_code = pha.currency_code