2 Replies Latest reply on Oct 8, 2009 1:01 PM by 49958

    How to get to PO_DISTRIBUTIONS_ALL table from Projects tables

    49958
      Hi,

      I have a requirement to add the column PO.PO_DISTRIBUTIONS_ALL.DELIVER_TO_PERSON_ID to an existing report that is built using the following tables:

      pa_expend_items_adjust2_v
      pa_cost_distribution_lines_all
      po_vendors
      ap_invoices_v
      gl_code_combinations
      gl_periods

      The view pa_expend_items_adjust2_v is based on the following tables:
      pa_projects_all
      pa_tasks
      pa_expenditure_items_all
      pa_expenditures_all
      pa_project_types_all
      pa_transaction_sources
      hr_all_organization_units_tl
      per_jobs

      I am unable to find the table linkage between the tables already used in the report to the column in the table I need to add. I can easily get the PO_NUMBER in the report but can't get down to the LINE_ID and/or PO_DISTRIBUTION_ID level.

      Does anyone have a query for doing this?

      Thank you very much!

      Suzanne