[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 |