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 298: ,po_headers_all poh

294: pod.rate_date currency_conv_date
295: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
296: ,po_line_locations_all poll
297: ,po_lines_all pol
298: ,po_headers_all poh
299: WHERE pol.po_header_id = poh.po_header_id
300: AND poll.po_line_id = pol.po_line_id
301: AND pod.line_location_id = poll.line_location_id
302: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')

Line 373: ,po_headers_all poh

369: pod.rate_date currency_conv_date
370: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
371: ,po_line_locations_all poll
372: ,po_lines_all pol
373: ,po_headers_all poh
374: ,po_vendors pov
375: WHERE pol.po_header_id = poh.po_header_id
376: AND poll.po_line_id = pol.po_line_id
377: AND pod.line_location_id = poll.line_location_id

Line 449: ,po_headers_all poh

445: pod.rate_date currency_conv_date
446: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
447: ,po_line_locations_all poll
448: ,po_lines_all pol
449: ,po_headers_all poh
450: ,po_vendors pov
451: WHERE pol.po_header_id = poh.po_header_id
452: AND poll.po_line_id = pol.po_line_id
453: AND pod.line_location_id = poll.line_location_id

Line 529: ,po_headers_all poh

525: pod.rate_date currency_conv_date
526: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
527: ,po_line_locations_all poll
528: ,po_lines_all pol
529: ,po_headers_all poh
530: ,mtl_categories_kfv mca
531: ,mtl_default_sets_view mds
532: WHERE pol.po_header_id = poh.po_header_id
533: AND poll.po_line_id = pol.po_line_id

Line 608: ,po_headers_all poh

604: pod.rate_date currency_conv_date
605: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
606: ,po_line_locations_all poll
607: ,po_lines_all pol
608: ,po_headers_all poh
609: ,mtl_categories_kfv mca
610: ,mtl_default_sets_view mds
611: WHERE pol.po_header_id = poh.po_header_id
612: AND poll.po_line_id = pol.po_line_id