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 300: ,po_lines_all pol

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

Line 378: ,po_lines_all pol

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

Line 457: ,po_lines_all pol

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

Line 540: ,po_lines_all pol

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

Line 622: ,po_lines_all pol

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

Line 2758: po_lines_all pol,

2754: 0)
2755: INTO l_quantity_invoiced
2756: FROM ap_invoice_distributions_all aida,
2757: ap_invoices_all aia,
2758: po_lines_all pol,
2759: po_line_locations_all poll,
2760: po_distributions_all pod
2761: WHERE aida.po_distribution_id = pod.po_distribution_id
2762: AND (p_rcv_txn_id IS NULL OR aida.rcv_transaction_id = p_rcv_txn_id)