DBA Data[Home] [Help]

APPS.CST_PERENDACCRUALS_PVT dependencies on PO_LINES_ALL

Line 198: po_lines_all pol,

194: poh.rate_type curr_conv_type,
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

Line 297: ,po_lines_all pol

293: poh.rate_type curr_conv_type,
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

Line 372: ,po_lines_all pol

368: poh.rate_type curr_conv_type,
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

Line 448: ,po_lines_all pol

444: poh.rate_type curr_conv_type,
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

Line 528: ,po_lines_all pol

524: poh.rate_type curr_conv_type,
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

Line 607: ,po_lines_all pol

603: poh.rate_type curr_conv_type,
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

Line 2643: po_lines_all pol,

2639: 0)
2640: INTO l_quantity_invoiced
2641: FROM ap_invoice_distributions_all aida,
2642: ap_invoices_all aia,
2643: po_lines_all pol,
2644: po_line_locations_all poll,
2645: po_distributions_all pod
2646: WHERE aida.po_distribution_id = pod.po_distribution_id
2647: AND (p_rcv_txn_id IS NULL OR aida.rcv_transaction_id = p_rcv_txn_id)