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 296: ,po_line_locations_all poll

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

Line 371: ,po_line_locations_all poll

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

Line 447: ,po_line_locations_all poll

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

Line 527: ,po_line_locations_all poll

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

Line 606: ,po_line_locations_all poll

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

Line 2644: po_line_locations_all poll,

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