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: AR_XLA_CTLGD_LINES_V

Product:	AR - Receivables
Description:	help reports to read the CCID from XLA
Implementation/DBA Data:	APPS.AR_XLA_CTLGD_LINES_V

View Text

SELECT CTLGD.CUST_TRX_LINE_GL_DIST_ID
, CTLGD.CUSTOMER_TRX_LINE_ID
, AE.GL_SL_LINK_ID
, AE.GL_SL_LINK_TABLE
, AE.CODE_COMBINATION_ID
, CTLGD.SET_OF_BOOKS_ID
, CTLGD.PERCENT
, DECODE(AE.ACCOUNTING_CLASS_CODE
, 'RECEIVABLE'
, NVL(LK.UNROUNDED_ENTERED_DR
, 0)-NVL(LK.UNROUNDED_ENTERED_CR
, 0)
, 'FV_REC_DR'
, NVL(LK.UNROUNDED_ENTERED_DR
, 0)-NVL(LK.UNROUNDED_ENTERED_CR
, 0)
, 'FV_REC_CR'
, NVL(LK.UNROUNDED_ENTERED_DR
, 0)-NVL(LK.UNROUNDED_ENTERED_CR
, 0)
, NVL(LK.UNROUNDED_ENTERED_CR
, 0)-NVL(LK.UNROUNDED_ENTERED_DR
, 0))
, CTLGD.GL_DATE
, CTLGD.GL_POSTED_DATE
, CTLGD.CUST_TRX_LINE_SALESREP_ID
, CTLGD.COMMENTS
, CTLGD.ATTRIBUTE_CATEGORY
, CTLGD.ATTRIBUTE1
, CTLGD.ATTRIBUTE2
, CTLGD.ATTRIBUTE3
, CTLGD.ATTRIBUTE4
, CTLGD.ATTRIBUTE5
, CTLGD.ATTRIBUTE6
, CTLGD.ATTRIBUTE7
, CTLGD.ATTRIBUTE8
, CTLGD.ATTRIBUTE9
, CTLGD.ATTRIBUTE10
, CTLGD.CONCATENATED_SEGMENTS
, CTLGD.ORIGINAL_GL_DATE
, CTLGD.POST_REQUEST_ID
, CTLGD.POSTING_CONTROL_ID
, DECODE(AE.ACCOUNTING_CLASS_CODE
, 'RECEIVABLE'
, 'REC'
, 'FV_REC_DR'
, 'REC'
, 'FV_REC_CR'
, 'REC'
, CTLGD.ACCOUNT_CLASS)
, CTLGD.RA_POST_LOOP_NUMBER
, CTLGD.CUSTOMER_TRX_ID
, CTLGD.ACCOUNT_SET_FLAG
, DECODE(AE.ACCOUNTING_CLASS_CODE
, 'RECEIVABLE'
, NVL(LK.UNROUNDED_ACCOUNTED_DR
, 0)-NVL(LK.UNROUNDED_ACCOUNTED_CR
, 0)
, 'FV_REC_DR'
, NVL(LK.UNROUNDED_ACCOUNTED_DR
, 0)-NVL(LK.UNROUNDED_ACCOUNTED_CR
, 0)
, 'FV_REC_CR'
, NVL(LK.UNROUNDED_ACCOUNTED_DR
, 0)-NVL(LK.UNROUNDED_ACCOUNTED_CR
, 0)
, NVL(LK.UNROUNDED_ACCOUNTED_CR
, 0)-NVL(LK.UNROUNDED_ACCOUNTED_DR
, 0))
, CTLGD.USSGL_TRANSACTION_CODE
, CTLGD.USSGL_TRANSACTION_CODE_CONTEXT
, CTLGD.ATTRIBUTE11
, CTLGD.ATTRIBUTE12
, CTLGD.ATTRIBUTE13
, CTLGD.ATTRIBUTE14
, CTLGD.ATTRIBUTE15
, CTLGD.LATEST_REC_FLAG
, CTLGD.ORG_ID
, CTLGD.MRC_ACCOUNT_CLASS
, CTLGD.MRC_CUSTOMER_TRX_ID
, CTLGD.MRC_AMOUNT
, CTLGD.MRC_GL_POSTED_DATE
, CTLGD.MRC_POSTING_CONTROL_ID
, CTLGD.MRC_ACCTD_AMOUNT
, CTLGD.COLLECTED_TAX_CCID
, CTLGD.COLLECTED_TAX_CONCAT_SEG
, CTLGD.REVENUE_ADJUSTMENT_ID
, CTLGD.REV_ADJ_CLASS_TEMP
, CTLGD.REC_OFFSET_FLAG
, CTLGD.EVENT_ID
, AE.AE_HEADER_ID
, CTLGD.LAST_UPDATE_DATE
, CTLGD.LAST_UPDATED_BY
, CTLGD.CREATION_DATE
, CTLGD.CREATED_BY
, CTLGD.REQUEST_ID
, AE.AE_LINE_NUM
FROM RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
, XLA_DISTRIBUTION_LINKS LK
, XLA_AE_HEADERS HD
, XLA_AE_LINES AE
FROM RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE CTLGD.CUST_TRX_LINE_GL_DIST_ID = LK.SOURCE_DISTRIBUTION_ID_NUM_1
AND AE.APPLICATION_ID = 222
AND LK.SOURCE_DISTRIBUTION_TYPE = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
AND LK.APPLICATION_ID = 222
AND LK.AE_HEADER_ID = AE.AE_HEADER_ID
AND LK.AE_LINE_NUM = AE.AE_LINE_NUM
AND LK.AE_HEADER_ID = HD.AE_HEADER_ID
AND HD.LEDGER_ID = CTLGD.SET_OF_BOOKS_ID
AND CTLGD.EVENT_ID IS NOT NULL
AND AE.ACCOUNTING_CLASS_CODE IN ( 'RECEIVABLE'
, 'REVENUE'
, 'REFUND'
, 'UNBILL'
, 'UNEARNED_REVENUE'
, 'TAX'
, 'CHARGES'
, 'FREIGHT'
, 'ROUNDING'
, 'FV_REC_DR'
, 'FV_REC_CR'
, 'ACCRUAL') UNION SELECT CTLGD.CUST_TRX_LINE_GL_DIST_ID
, CTLGD.CUSTOMER_TRX_LINE_ID
, NULL
, NULL
, CTLGD.CODE_COMBINATION_ID
, CTLGD.SET_OF_BOOKS_ID
, CTLGD.PERCENT
, CTLGD.AMOUNT
, CTLGD.GL_DATE
, CTLGD.GL_POSTED_DATE
, CTLGD.CUST_TRX_LINE_SALESREP_ID
, CTLGD.COMMENTS
, CTLGD.ATTRIBUTE_CATEGORY
, CTLGD.ATTRIBUTE1
, CTLGD.ATTRIBUTE2
, CTLGD.ATTRIBUTE3
, CTLGD.ATTRIBUTE4
, CTLGD.ATTRIBUTE5
, CTLGD.ATTRIBUTE6
, CTLGD.ATTRIBUTE7
, CTLGD.ATTRIBUTE8
, CTLGD.ATTRIBUTE9
, CTLGD.ATTRIBUTE10
, CTLGD.CONCATENATED_SEGMENTS
, CTLGD.ORIGINAL_GL_DATE
, CTLGD.POST_REQUEST_ID
, CTLGD.POSTING_CONTROL_ID
, CTLGD.ACCOUNT_CLASS
, CTLGD.RA_POST_LOOP_NUMBER
, CTLGD.CUSTOMER_TRX_ID
, CTLGD.ACCOUNT_SET_FLAG
, CTLGD.ACCTD_AMOUNT
, CTLGD.USSGL_TRANSACTION_CODE
, CTLGD.USSGL_TRANSACTION_CODE_CONTEXT
, CTLGD.ATTRIBUTE11
, CTLGD.ATTRIBUTE12
, CTLGD.ATTRIBUTE13
, CTLGD.ATTRIBUTE14
, CTLGD.ATTRIBUTE15
, CTLGD.LATEST_REC_FLAG
, CTLGD.ORG_ID
, CTLGD.MRC_ACCOUNT_CLASS
, CTLGD.MRC_CUSTOMER_TRX_ID
, CTLGD.MRC_AMOUNT
, CTLGD.MRC_GL_POSTED_DATE
, CTLGD.MRC_POSTING_CONTROL_ID
, CTLGD.MRC_ACCTD_AMOUNT
, CTLGD.COLLECTED_TAX_CCID
, CTLGD.COLLECTED_TAX_CONCAT_SEG
, CTLGD.REVENUE_ADJUSTMENT_ID
, CTLGD.REV_ADJ_CLASS_TEMP
, CTLGD.REC_OFFSET_FLAG
, CTLGD.EVENT_ID
, NULL
, CTLGD.LAST_UPDATE_DATE
, CTLGD.LAST_UPDATED_BY
, CTLGD.CREATION_DATE
, CTLGD.CREATED_BY
, CTLGD.REQUEST_ID
, NULL
FROM RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE CTLGD.POSTING_CONTROL_ID <> -3
AND CTLGD.EVENT_ID IS NULL

Columns

Name
CUST_TRX_LINE_GL_DIST_ID
CUSTOMER_TRX_LINE_ID
GL_SL_LINK_ID
GL_SL_LINK_TABLE
CODE_COMBINATION_ID
SET_OF_BOOKS_ID
PERCENT
AMOUNT
GL_DATE
GL_POSTED_DATE
CUST_TRX_LINE_SALESREP_ID
COMMENTS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
CONCATENATED_SEGMENTS
ORIGINAL_GL_DATE
POST_REQUEST_ID
POSTING_CONTROL_ID
ACCOUNT_CLASS
RA_POST_LOOP_NUMBER
CUSTOMER_TRX_ID
ACCOUNT_SET_FLAG
ACCTD_AMOUNT
USSGL_TRANSACTION_CODE
USSGL_TRANSACTION_CODE_CONTEXT
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
LATEST_REC_FLAG
ORG_ID
MRC_ACCOUNT_CLASS
MRC_CUSTOMER_TRX_ID
MRC_AMOUNT
MRC_GL_POSTED_DATE
MRC_POSTING_CONTROL_ID
MRC_ACCTD_AMOUNT
COLLECTED_TAX_CCID
COLLECTED_TAX_CONCAT_SEG
REVENUE_ADJUSTMENT_ID
REV_ADJ_CLASS_TEMP
REC_OFFSET_FLAG
EVENT_ID
AE_HEADER_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
REQUEST_ID
AE_LINE_NUM