Saturday 19 November 2011

GL_XLA_AP

SELECT
apd.*
FROM
GL.GL_LEDGERS GL
,GL.GL_JE_BATCHES GLB
,GL.GL_JE_HEADERS GLH
,GL.GL_JE_LINES GLL
,GL.GL_IMPORT_REFERENCES GLIR
,XLA.XLA_AE_LINES XLL
,XLA.XLA_AE_HEADERS XLH
,XLA.XLA_EVENTS XLE
,XLA.XLA_TRANSACTION_ENTITIES XLTE
,XLA.XLA_DISTRIBUTION_LINKS XLDL
,ap.ap_invoices_all aph
,ap.ap_invoice_lines_all apl
,ap.ap_invoice_distributions_all apd
WHERE
GL.CHART_OF_ACCOUNTS_ID = GLB.CHART_OF_ACCOUNTS_ID AND
GL.PERIOD_SET_NAME = GLB.PERIOD_SET_NAME AND
GL.ACCOUNTED_PERIOD_TYPE = GLB.ACCOUNTED_PERIOD_TYPE AND
GLB.JE_BATCH_ID = GLH.JE_BATCH_ID AND
GLH.JE_HEADER_ID = GLL.JE_HEADER_ID AND
GLL.JE_HEADER_ID = GLIR.JE_HEADER_ID AND
GLL.JE_LINE_NUM = GLIR.JE_LINE_NUM AND
GLIR.GL_SL_LINK_TABLE = XLL.GL_SL_LINK_TABLE AND
GLIR.GL_SL_LINK_ID = XLL.GL_SL_LINK_ID AND
XLL.APPLICATION_ID = XLH.APPLICATION_ID AND
XLL.AE_HEADER_ID = XLH.AE_HEADER_ID AND
XLH.APPLICATION_ID = XLE.APPLICATION_ID AND
XLH.EVENT_ID = XLE.EVENT_ID AND
XLE.APPLICATION_ID = XLTE.APPLICATION_ID AND
XLE.ENTITY_ID = XLTE.ENTITY_ID AND
XLL.APPLICATION_ID = XLDL.APPLICATION_ID AND
XLL.AE_HEADER_ID = XLDL.AE_HEADER_ID AND
XLL.AE_LINE_NUM = XLDL.AE_LINE_NUM AND
XLTE.SOURCE_ID_INT_1 = aph.invoice_id AND
aph.invoice_id = apl.invoice_id AND
apl.invoice_id = apd.invoice_id AND
apl.line_number = apd.invoice_line_number AND
XLDL.SOURCE_DISTRIBUTION_ID_NUM_1 = apd.invoice_distribution_id

1 comment:

  1. 25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students

    Please Check https://www.oracleappstechnical.com for details

    ReplyDelete