View: AR_CUST_TRX_LINES_BASE_V

Product:	AR - Receivables
Description:	transaction line base extract
Implementation/DBA Data:	APPS.AR_CUST_TRX_LINES_BASE_V

View Text

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'

Columns