2 Replies Latest reply on Dec 27, 2018 9:50 AM by Ebenezer Illango

    PO Tables holding sum amount

    Ebenezer Illango

      Hi Team,

       

      Can you please provide me the table name which holds the item level total amount and total PO amount?

       

      I tried with these tables.

      PO_Headers_All

      PO_Lines_all

      But

      These two has the amount billed column which gets updated only after an invoice generated.

      PO_Distributions_all

      PO_Line_Locations_All

       

      So, kindly please let me know about the table name which provides the individual sum and total sum in the PO.

       

      Thanks,

      Ebenezer Illango

        • 1. Re: PO Tables holding sum amount
          mdtaylor

          Look at po_line_locations_all.price_override.

           

          select poh.segment1 po_number,

                 decode(vnd.vendor_name,'','No Vendor',vnd.vendor_name) vendor_name,

                 pol.line_num,

                 pol.creation_date,

                 polt.line_type,

                 poh.note_to_receiver,

                 poh.comments,

                 pol.item_description,

                 hre.last_name||', '||substr(hre.first_name,1,1)||'.'  emp_name,

                 pol.unit_meas_lookup_code,

                 pod.quantity_ordered qty_ordered,

                 (pod.quantity_ordered) * poll.price_override amount

            from po_line_types_tl                  polt,

                 hr_employees                      hre,

                 gl_code_combinations              glcc,

                 po_vendors                        vnd,

                 gl_sets_of_books                  gsb,

                 financials_system_params_all      fsp,

                 po_distributions_all              pod,

                 po_line_locations_all             poll,

                 po_lines_all                      pol,

                 po_headers_all                    poh

          where poll.line_location_id           = pod.line_location_id

             and pol.po_header_id                = poh.po_header_id

             and poll.po_line_id                 = pol.po_line_id

             and pol.line_type_id                = polt.line_type_id

             and gsb.set_of_books_id             = fsp.set_of_books_id

             and gsb.chart_of_accounts_id        = glcc.chart_of_accounts_id

             and pod.code_combination_id         = glcc.code_combination_id

             and vnd.vendor_id                   = poh.vendor_id

             and hre.employee_id(+)              = pod.deliver_to_person_id

             and nvl(poh.cancel_flag,'N')        <> 'Y'

             and poh.type_lookup_code in ('STANDARD', 'BLANKET')

          1 person found this helpful
          • 2. Re: PO Tables holding sum amount
            Ebenezer Illango

            Hi Mdtaylor,

             

            Tons of Thanks!!!

             

            This one column saved my work po_line_locations_all.price_override.

             

            I didn't see your query but Thank you so much.

             

            Thanks and Regards!

            Ebenezer Illango