View: AR_XLA_ARD_RA_LINES_V

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

View Text

SELECT ARD.LINE_ID
, ARD.SOURCE_ID
, ARD.SOURCE_TABLE
, ARD.SOURCE_TYPE
, NULL
, NULL
, ARD.CODE_COMBINATION_ID
, ARD.AMOUNT_DR
, ARD.AMOUNT_CR
, ARD.ACCTD_AMOUNT_DR
, ARD.ACCTD_AMOUNT_CR
, ARD.ORG_ID
, ARD.SOURCE_TABLE_SECONDARY
, ARD.SOURCE_ID_SECONDARY
, ARD.CURRENCY_CODE
, ARD.CURRENCY_CONVERSION_RATE
, ARD.CURRENCY_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_DATE
, ARD.TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR
, ARD.TAX_LINK_ID
, ARD.THIRD_PARTY_ID
, ARD.THIRD_PARTY_SUB_ID
, ARD.REVERSED_SOURCE_ID
, ARD.TAX_CODE_ID
, ARD.LOCATION_SEGMENT_ID
, ARD.SOURCE_TYPE_SECONDARY
, ARD.TAX_GROUP_CODE_ID
, ARD.REF_CUSTOMER_TRX_LINE_ID
, ARD.REF_CUST_TRX_LINE_GL_DIST_ID
, ARD.REF_LINE_ID
, ARD.FROM_AMOUNT_DR
, ARD.FROM_AMOUNT_CR
, ARD.FROM_ACCTD_AMOUNT_DR
, ARD.FROM_ACCTD_AMOUNT_CR
, ARD.REF_ACCOUNT_CLASS
, ARD.ACTIVITY_BUCKET
, ARD.REF_DIST_CCID
, ARD.REF_MF_DIST_FLAG
, TO_NUMBER(NULL)
, RA.GL_DATE
, NULL
, ARD.CREATION_DATE
, ARD.CREATED_BY
, ARD.LAST_UPDATED_BY
, ARD.LAST_UPDATE_DATE
, TO_NUMBER(NULL)
, RA.CASH_RECEIPT_ID CASH_RECEIPT_ID
, RA.APPLICATION_TYPE APPLICATION_TYPE
, RA.POSTING_CONTROL_ID POSTING_CONTROL_ID
FROM AR_DISTRIBUTIONS_ALL ARD
, AR_RECEIVABLE_APPLICATIONS_ALL RA
WHERE RA.POSTING_CONTROL_ID <> -3
AND ARD.SOURCE_TABLE = 'RA'
AND ARD.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND RA.STATUS IN('APP'
, 'ACC'
, 'ACTIVITY'
, 'OTHER ACC')
AND RA.EVENT_ID IS NULL UNION SELECT ARD.LINE_ID
, ARD.SOURCE_ID
, ARD.SOURCE_TABLE
, ARD.SOURCE_TYPE
, NULL
, NULL
, ARD.CODE_COMBINATION_ID
, ARD.AMOUNT_DR
, ARD.AMOUNT_CR
, ARD.ACCTD_AMOUNT_DR
, ARD.ACCTD_AMOUNT_CR
, ARD.ORG_ID
, ARD.SOURCE_TABLE_SECONDARY
, ARD.SOURCE_ID_SECONDARY
, ARD.CURRENCY_CODE
, ARD.CURRENCY_CONVERSION_RATE
, ARD.CURRENCY_CONVERSION_TYPE
, ARD.CURRENCY_CONVERSION_DATE
, ARD.TAXABLE_ENTERED_DR
, ARD.TAXABLE_ENTERED_CR
, ARD.TAXABLE_ACCOUNTED_DR
, ARD.TAXABLE_ACCOUNTED_CR
, ARD.TAX_LINK_ID
, ARD.THIRD_PARTY_ID
, ARD.THIRD_PARTY_SUB_ID
, ARD.REVERSED_SOURCE_ID
, ARD.TAX_CODE_ID
, ARD.LOCATION_SEGMENT_ID
, ARD.SOURCE_TYPE_SECONDARY
, ARD.TAX_GROUP_CODE_ID
, ARD.REF_CUSTOMER_TRX_LINE_ID
, ARD.REF_CUST_TRX_LINE_GL_DIST_ID
, ARD.REF_LINE_ID
, ARD.FROM_AMOUNT_DR
, ARD.FROM_AMOUNT_CR
, ARD.FROM_ACCTD_AMOUNT_DR
, ARD.FROM_ACCTD_AMOUNT_CR
, ARD.REF_ACCOUNT_CLASS
, ARD.ACTIVITY_BUCKET
, ARD.REF_DIST_CCID
, ARD.REF_MF_DIST_FLAG
, TO_NUMBER(NULL)
, RA.GL_DATE
, NULL
, ARD.CREATION_DATE
, ARD.CREATED_BY
, ARD.LAST_UPDATED_BY
, ARD.LAST_UPDATE_DATE
, TO_NUMBER(NULL)
, RA.CASH_RECEIPT_ID CASH_RECEIPT_ID
, RA.APPLICATION_TYPE APPLICATION_TYPE
, RA.POSTING_CONTROL_ID POSTING_CONTROL_ID
FROM AR_DISTRIBUTIONS_ALL ARD
, AR_RECEIVABLE_APPLICATIONS_ALL RA
WHERE RA.POSTING_CONTROL_ID <> -3
AND ARD.SOURCE_TABLE = 'RA'
AND ARD.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID
AND RA.STATUS IN('UNAPP'
, 'UNID')
AND RA.EVENT_ID IS NULL
AND EXISTS (SELECT NULL
FROM XLA_DISTRIBUTION_LINKS LK
WHERE LK.SOURCE_DISTRIBUTION_ID_NUM_1 = ARD.LINE_ID
AND LK.APPLICATION_ID = 222
AND LK.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL' )

Columns