DBA Data[Home] [Help]

APPS.CST_PERENDACCRUALS_PVT dependencies on PO_HEADERS_ALL

Line 199: po_headers_all poh,

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

Line 301: ,po_headers_all poh

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

Line 379: ,po_headers_all poh

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

Line 458: ,po_headers_all poh

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

Line 541: ,po_headers_all poh

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

Line 623: ,po_headers_all poh

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