APPS.PA_CONTROL_API_PVT dependencies on PO_LINES_ALL

Line 482: l_line_id po_lines_all.po_line_id%TYPE;

478: l_vendor_id po_vendors.vendor_id%TYPE;
479: l_supplier_name po_vendors.vendor_name%TYPE;
480: l_po_number po_headers_all.segment1%TYPE;
481: l_header_id po_headers_all.po_header_id%TYPE;
482: l_line_id po_lines_all.po_line_id%TYPE;
483: l_line_num po_lines_all.line_num%TYPE;
484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;

Line 483: l_line_num po_lines_all.line_num%TYPE;

479: l_supplier_name po_vendors.vendor_name%TYPE;
480: l_po_number po_headers_all.segment1%TYPE;
481: l_header_id po_headers_all.po_header_id%TYPE;
482: l_line_id po_lines_all.po_line_id%TYPE;
483: l_line_num po_lines_all.line_num%TYPE;
484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;

Line 567: From po_lines_all pol

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
570: Where poh.po_header_id = pol.po_header_id
571: and pod.po_header_id = pol.po_header_id

Line 589: From po_lines_all pol

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
592: Where poh.po_header_id = pol.po_header_id
593: and pod.po_header_id = pol.po_header_id