VRM_XLA_MEMOLINE

Details

Name
MEMO_LINE_NAME MEMO_LINE_REV_CCID EVENT_ID LINE_NUMBER LEDGER_ID

Name

MEMO_LINE_NAME

MEMO_LINE_REV_CCID

EVENT_ID

LINE_NUMBER

LEDGER_ID

SQL_Statement
SELECT /* Bug22157447: Removed the group by expression to improve the performance of SLA Clob Query which generates accounting entries*/ memo.NAME MEMO_LINE_NAME, ref.rev_ccid MEMO_LINE_REV_CCID , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id FROM ar_ref_accounts_All REF, VRM_XLA_IFRS15_EXTRACT_GT l, ar_memo_lines_all_vl memo WHERE l.level_code = 'L' AND REF.source_ref_table(+) = 'AR_MEMO_LINES_ALL_B' AND REF.bu_id(+) = l.bu_id AND l.memo_line_seq_id = memo.memo_line_seq_id AND l.memo_line_seq_id = REF.source_ref_account_id(+)

SQL_Statement

SELECT /* Bug22157447: Removed the group by expression to improve the performance of SLA Clob Query which generates accounting entries*/

memo.NAME MEMO_LINE_NAME,

ref.rev_ccid MEMO_LINE_REV_CCID ,

l.event_id event_id ,

l.line_number line_number ,

l.ledger_id ledger_id

FROM ar_ref_accounts_All REF,

VRM_XLA_IFRS15_EXTRACT_GT l,

ar_memo_lines_all_vl memo

WHERE l.level_code = 'L'

AND REF.source_ref_table(+) = 'AR_MEMO_LINES_ALL_B'

AND REF.bu_id(+) = l.bu_id

AND l.memo_line_seq_id = memo.memo_line_seq_id

AND l.memo_line_seq_id = REF.source_ref_account_id(+)