1. Tables and Views for Financials
  2. AR_CM_BATCHES_S_V

AR_CM_BATCHES_S_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CM_BATCH_DATE

CM_BATCH_ID

CM_BATCH_COMMENTS

CM_BATCH_NAME

EVENT_ID

LINE_NUMBER

LEDGER_ID

LANGUAGE

Query

SQL_Statement

SELECT bac1.batch_date cm_batch_date ,

bac1.batch_id cm_batch_id ,

bac1.comments cm_batch_comments ,

bac1.name cm_batch_name ,

he.event_id event_id ,

he.line_number line_number ,

he.ledger_id ledger_id ,

he.language language

FROM ra_batches_all bac1,

ar_xla_lines_extract he

WHERE bac1.batch_source_seq_id = he.batch_source_seq_id

AND he.event_class_code = 'CREDIT_MEMO'

AND he.level_flag = 'H'