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