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_CUST_TRX_LINES_BASE_V

Source

View Text - Preformatted


SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ HE.EVENT_ID EVENT_ID ,CTLGD.CUST_TRX_LINE_GL_DIST_ID LINE_ID ,HE.BASE_CURRENCY_CODE TRX_LINE_CUR_CODE ,HE.EXCHANGE_RATE_TYPE TRX_LINE_CUR_CONVERSION_TYPE ,HE.EXCHANGE_DATE TRX_LINE_CUR_CONVERSION_DATE ,HE.EXCHANGE_RATE TRX_LINE_CUR_CONVERSION_RATE ,HE.ACCTD_AMOUNT TRX_LINE_ACCTD_AMT ,HE.LINE_NUMBER LINE_NUMBER ,HE.LANGUAGE LANGUAGE ,HE.LEDGER_ID LEDGER_ID ,CTLGD.ROUNDING_CORRECTION_FLAG ROUNDING_CORRECTION_FLAG FROM AR_XLA_LINES_EXTRACT HE ,RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD WHERE HE.CUST_TRX_LINE_GL_DIST_ID IS NOT NULL AND HE.level_flag = 'L' AND HE.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID AND HE.POSTING_ENTITY = 'CTLGD'

View Text - HTML Formatted

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ HE.EVENT_ID EVENT_ID
, CTLGD.CUST_TRX_LINE_GL_DIST_ID LINE_ID
, HE.BASE_CURRENCY_CODE TRX_LINE_CUR_CODE
, HE.EXCHANGE_RATE_TYPE TRX_LINE_CUR_CONVERSION_TYPE
, HE.EXCHANGE_DATE TRX_LINE_CUR_CONVERSION_DATE
, HE.EXCHANGE_RATE TRX_LINE_CUR_CONVERSION_RATE
, HE.ACCTD_AMOUNT TRX_LINE_ACCTD_AMT
, HE.LINE_NUMBER LINE_NUMBER
, HE.LANGUAGE LANGUAGE
, HE.LEDGER_ID LEDGER_ID
, CTLGD.ROUNDING_CORRECTION_FLAG ROUNDING_CORRECTION_FLAG
FROM AR_XLA_LINES_EXTRACT HE
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE HE.CUST_TRX_LINE_GL_DIST_ID IS NOT NULL
AND HE.LEVEL_FLAG = 'L'
AND HE.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID
AND HE.POSTING_ENTITY = 'CTLGD'