195: pod.rate_date currency_conv_date
196: FROM po_distributions pod, -- Using single org view PO_DISTRIBUTIONS to support MOAC
197: po_line_locations_all poll,
198: po_lines_all pol,
199: po_headers_all poh,
200: po_vendors pov,
201: mtl_categories_kfv mca,
202: mtl_default_sets_view mds
203: WHERE pol.po_header_id = poh.po_header_id
297: pod.rate_date currency_conv_date
298: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
299: ,po_line_locations_all poll
300: ,po_lines_all pol
301: ,po_headers_all poh
302: WHERE pol.po_header_id = poh.po_header_id
303: AND poh.pcard_id IS NULL
304: AND poll.po_line_id = pol.po_line_id
305: AND pod.line_location_id = poll.line_location_id
375: pod.rate_date currency_conv_date
376: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
377: ,po_line_locations_all poll
378: ,po_lines_all pol
379: ,po_headers_all poh
380: ,po_vendors pov
381: WHERE pol.po_header_id = poh.po_header_id
382: AND poh.pcard_id IS NULL
383: AND poll.po_line_id = pol.po_line_id
454: pod.rate_date currency_conv_date
455: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
456: ,po_line_locations_all poll
457: ,po_lines_all pol
458: ,po_headers_all poh
459: ,po_vendors pov
460: WHERE pol.po_header_id = poh.po_header_id
461: AND poh.pcard_id IS NULL
462: AND poll.po_line_id = pol.po_line_id
537: pod.rate_date currency_conv_date
538: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
539: ,po_line_locations_all poll
540: ,po_lines_all pol
541: ,po_headers_all poh
542: ,mtl_categories_kfv mca
543: ,mtl_default_sets_view mds
544: WHERE pol.po_header_id = poh.po_header_id
545: AND poh.pcard_id IS NULL
619: pod.rate_date currency_conv_date
620: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
621: ,po_line_locations_all poll
622: ,po_lines_all pol
623: ,po_headers_all poh
624: ,mtl_categories_kfv mca
625: ,mtl_default_sets_view mds
626: WHERE pol.po_header_id = poh.po_header_id
627: AND poh.pcard_id IS NULL