AR_CUST_TRX_LINES_BASE_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
EVENT_ID LINE_ID TRX_LINE_CUR_CODE TRX_LINE_CUR_CONVERSION_TYPE TRX_LINE_CUR_CONVERSION_DATE TRX_LINE_CUR_CONVERSION_RATE TRX_LINE_ACCTD_AMT LINE_NUMBER LANGUAGE LEDGER_ID ROUNDING_CORRECTION_FLAG

Query

SQL_Statement

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' UNION ALL SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ HE.EVENT_ID EVENT_ID, ZX.TAX_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, ZX.TAX_DIST_AMT_TAX_CURR TRX_LINE_ACCTD_AMT, -ZX.TAX_DIST_ID LINE_NUMBER, HE.LANGUAGE LANGUAGE, ZX.LEDGER_ID LEDGER_ID, 'N' ROUNDING_CORRECTION_FLAG FROM AR_XLA_LINES_EXTRACT HE , ZX_TRX_TAX_DISTRIBUTIONS zx WHERE HE.CUST_TRX_LINE_GL_DIST_ID IS NOT NULL AND HE.event_id = zx.ACCOUNTING_EVENT_ID AND HE.level_flag = 'L' AND HE.CUST_TRX_LINE_GL_DIST_ID = zx.TRX_LINE_DIST_ID AND HE.POSTING_ENTITY = 'CTLGD' AND zx.application_id = 222 AND zx.entity_code = 'TRANSACTIONS' AND zx.event_class_code = 'INVOICE'