DBA Data[Home] [Help]

APPS.CST_PERENDACCRUALS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 197: po_line_locations_all poll,

193: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
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,

Line 299: ,po_line_locations_all poll

295: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
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

Line 377: ,po_line_locations_all poll

373: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
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

Line 456: ,po_line_locations_all poll

452: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
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

Line 539: ,po_line_locations_all poll

535: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
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

Line 621: ,po_line_locations_all poll

617: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
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

Line 2759: po_line_locations_all poll,

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)
2763: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY','REC_TAX')