Cloud Financials: payables link to projects account distribution

Question

Summary

Need DB links between Financials and Projects tables

Content

In E-Business Suite, the payables distribution contains the project_id and task_id which link to the Projects tables for invoices matched to projects/tasks.  Does anyone have the links between the Cloud/fusion tables?

Matthew Bez · Answer

select s.vendor_name, i.invoice_num, i.invoice_date,  L.amount amt,

P.segment1 , E.Name ,T.EXPENDITURE_TYPE_NAME

from AP_INVOICE_DISTRIBUTIONS_ALL L, AP_INVOICES_ALL I, POZ_SUPPLIERS_V S, PJF_EXP_TYPES_TL T, PJF_PROJECTS_ALL_B P, PJF_PROJ_ELEMENTS_TL E

where i.invoice_id = l.Invoice_id

and s.vendor_id = i.vendor_id

and L.reversal_flag <> 'Y'

and T.EXPENDITURE_TYPE_ID =  L.PJC_EXPENDITURE_TYPE_ID

and P.Project_id = L.PJC_PROJECT_ID

and T.EXPENDITURE_TYPE_NAME='COS Rent'

and E.PROJ_ELEMENT_ID = L.PJC_TASK_ID

PLW · Answer

BI Publisher reporting

Xavier Cuinier · Answer

Hi Pam

What is the primary reason for asking this ?

Xavier