Oracle Fusion – AR Receipts To SLA to GL Link Query
SELECT glp.start_date,
gjh.je_header_id,
gjh.doc_sequence_value voucher_no,
gjh.je_source,
gjh.je_category,
entity_code,
gjh.period_name,
gjh.status,
gjh.actual_flag,
gjh.default_effective_date,
gjl.je_line_num,
gjl.code_combination_id,
gjl.description voucher_desc,
xal.accounted_dr debit,
xal.accounted_cr credit,
gcc.segment1 || '.' || gcc.segment2 || '-' || gcc.segment3 || '-' ||
gcc.segment4 || '-' || gcc.segment5 || '-' || gcc.segment6 || '-' ||
gcc.segment7 || '-' || gcc.segment8 || '-' || gcc.segment9 account_code,
TO_CHAR (acr.receipt_number) trx_num,
acr.receipt_date trx_date
FROM gl_je_headers gjh,
gl_je_lines gjl,
gl_code_combinations gcc,
gl_periods glp,
gl_import_references imp,
xla_ae_lines xal,
xla_ae_headers xah,
xla_events xe,
xla_transaction_entities xte,
ar_cash_receipts_all acr
WHERE 1 = 1
AND gjh.je_header_id = gjl.je_header_id
AND gjl.status || '' = 'P'
AND gjl.code_combination_id = gcc.code_combination_id
AND gjh.period_name = glp.period_name
AND glp.adjustment_period_flag <> 'Y'
AND gjh.je_source = 'Receivables'
AND gjl.je_header_id = imp.je_header_id
AND gjl.je_line_num = imp.je_line_num
AND imp.gl_sl_link_id = xal.gl_sl_link_id
AND imp.gl_sl_link_table = xal.gl_sl_link_table
AND xal.application_id = xah.application_id
AND xal.ae_header_id = xah.ae_header_id
AND xah.application_id = xe.application_id
AND xah.event_id = xe.event_id
AND xe.application_id = xte.application_id
AND xte.application_id = 222
AND xe.entity_id = xte.entity_id
AND xte.entity_code = 'RECEIPTS'
AND xte.source_id_int_1 = acr.cash_receipt_id
Comments |0|
Category: OracleSaaS