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.

[Home] [Help]

View: AX_MC_AR_RACTLA_RACTLGDA_V

Product:	AX - Global Accounting Engine
Description:	Use for Oracle Receivables MRC rules creation
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RAMC1.SET_OF_BOOKS_ID
, RACTLA.CUSTOMER_TRX_ID
, RACTLA.CUSTOMER_TRX_LINE_ID
, RACTLA.LINK_TO_CUST_TRX_LINE_ID
, RACTLA.VAT_TAX_ID
, RACTLGDA1.CODE_COMBINATION_ID
, RACTLGDA1.CUST_TRX_LINE_GL_DIST_ID
, RACTLGDA1.GL_DATE
, RACTLGDA1.AMOUNT
, RAMC1.ACCTD_AMOUNT
, -1*RACTLA.TAXABLE_AMOUNT TAXABLE_AMOUNT
, -1*RAMC2.ACCTD_AMOUNT BASE_ACCTD_AMOUNT
FROM RA_MC_TRX_LINE_GL_DIST RAMC1
, RA_CUST_TRX_LINE_GL_DIST_ALL RACTLGDA1
, RA_CUST_TRX_LINE_GL_DIST_ALL RACTLGDA2
, RA_CUSTOMER_TRX_LINES_ALL RACTLA
, RA_MC_TRX_LINE_GL_DIST RAMC2
WHERE RACTLGDA1.CUSTOMER_TRX_LINE_ID = RACTLA.CUSTOMER_TRX_LINE_ID
AND RAMC1.CUST_TRX_LINE_GL_DIST_ID = RACTLGDA1.CUST_TRX_LINE_GL_DIST_ID
AND RACTLGDA1.ACCOUNT_CLASS = 'TAX'
AND RACTLGDA1.POSTING_CONTROL_ID < 0
AND RACTLGDA2.CUSTOMER_TRX_LINE_ID(+) = RACTLA.LINK_TO_CUST_TRX_LINE_ID
AND RAMC2.CUST_TRX_LINE_GL_DIST_ID = RACTLGDA2.CUST_TRX_LINE_GL_DIST_ID
AND RAMC2.SET_OF_BOOKS_ID = RAMC1.SET_OF_BOOKS_ID

Columns

Name
SET_OF_BOOKS_ID
CUSTOMER_TRX_ID
CUSTOMER_TRX_LINE_ID
LINK_TO_CUST_TRX_LINE_ID
VAT_TAX_ID
CODE_COMBINATION_ID
CUST_TRX_LINE_GL_DIST_ID
GL_DATE
AMOUNT
ACCTD_AMOUNT
TAXABLE_AMOUNT
BASE_ACCTD_AMOUNT