Sunday, March 20, 2016

Relation between AR,GL and XLA modules

SELECT
  rct.trx_number,
  b.NAME batch_name,
  b.description batch_description,
  h.je_category,
  h.je_source,
  h.period_name je_period_name,
  h.NAME journal_name,
  h.status journal_status,
  h.description je_description,
  l.je_line_num line_number
FROM
  gl_je_batches b,
  gl_je_headers h,
  gl_je_lines l,
  GL_IMPORT_REFERENCES GIR,
  xla_ae_lines xlal,
  xla_ae_headers xlah,
  xla_events xlae,
  xla.xla_transaction_entities xlate,
  ra_customer_trx_all rct
WHERE b.je_batch_id      = h.je_batch_id
AND H.JE_HEADER_ID       = L.JE_HEADER_ID
AND l.je_header_id       = gir.je_header_id
AND L.je_line_NUM        = GIR.je_line_NUM
AND gir.je_batch_id      =b.je_batch_id
AND GIR.GL_SL_LINK_TABLE = XLAL.GL_SL_LINK_TABLE
AND gir.gl_sl_link_id    = xlal.gl_sl_link_id
AND xlal.ae_header_id    = xlah.ae_header_id
AND xlah.event_id        = xlae.event_id
AND xlae.entity_id       = xlate.entity_id
AND xlae.application_id  = xlate.application_id
AND H.JE_SOURCE          = 'Receivables'
AND rct.CUSTOMER_TRX_ID  = xlate.SOURCE_ID_INT_1
AND trx_number           ='353454'

AND B.NAME               ='AX Receivables 2342323: A 345343';

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect