DBA Data[Home] [Help]

APPS.POS_TOTALS_PO_SV dependencies on PO_HEADERS_ALL

Line 167: from po_headers_all

163: if (X_doc_type in ('STANDARD')) then
164:
165: select org_id
166: into x_org_id
167: from po_headers_all
168: where po_header_id = x_header_id;
169:
170: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ;
171:

Line 396: FROM PO_HEADERS_ALL POH,

392: SELECT fc.minimum_accountable_unit,
393: fc.precision
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

Line 517: po_headers_all pha,

513: fc.precision
514: INTO x_min_unit,
515: x_precision
516: FROM fnd_currencies fc,
517: po_headers_all pha,
518: po_line_locations_archive_all poll
519: WHERE poll.line_location_id = x_po_line_location_id
520: AND poll.po_header_id = pha.po_header_id
521: AND fc.currency_code = pha.currency_code

Line 581: po_headers_all pha,

577: fc.precision
578: INTO x_min_unit,
579: x_precision
580: FROM fnd_currencies fc,
581: po_headers_all pha,
582: po_line_locations_archive_all poll
583: WHERE poll.line_location_id = p_po_line_location_id
584: AND poll.po_header_id = pha.po_header_id
585: AND fc.currency_code = pha.currency_code