eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AR_CM_BATCHES_S_V

Source

View Text - Preformatted


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 he.batch_id = bac1.batch_id AND he.org_id = bac1.org_id AND he.event_class_code = 'CREDIT_MEMO' AND he.level_flag = 'H'

View Text - HTML Formatted

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 HE.BATCH_ID = BAC1.BATCH_ID
AND HE.ORG_ID = BAC1.ORG_ID
AND HE.EVENT_CLASS_CODE = 'CREDIT_MEMO'
AND HE.LEVEL_FLAG = 'H'