DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_EXPENDITURES_UTILS

Line 522: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname

518: ,po.vendor_id PoVendorId
519: ,v.vendor_name PoSupplierName
520: ,po.currency_code PoCurrency
521: ,po.org_id Poorgid
522: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname
523: ,pod.project_id PoProjectId
524: From po_headers_all po
525: ,po_vendors v
526: ,po_distributions_all pod

Line 543: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname

539: ,po.vendor_id PoVendorId
540: ,v.vendor_name PoSupplierName
541: ,po.currency_code PoCurrency
542: ,po.org_id Poorgid
543: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname
544: ,pod.project_id PoProjectId
545: From po_headers_all po
546: ,po_vendors v
547: ,po_distributions_all pod

Line 565: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname

561: ,(pol.quantity * pol.unit_price) PolineAmount
562: ,poh.po_header_id Poheaderid
563: ,poh.segment1 Ponumber
564: ,pod.project_id Projectid
565: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname
566: ,pod.po_distribution_id Podistid
567: From po_lines_all pol
568: ,po_headers_all poh
569: ,po_distributions_all pod

Line 587: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname

583: ,(pol.quantity * pol.unit_price) PolineAmount
584: ,poh.po_header_id Poheaderid
585: ,poh.segment1 Ponumber
586: ,pod.project_id Projectid
587: ,substr(pa_expenditures_utils.getorgtlname(pod.org_id),1,30) Ouname
588: ,pod.po_distribution_id Podistid
589: From po_lines_all pol
590: ,po_headers_all poh
591: ,po_distributions_all pod