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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AR_XLA_ARD_RA_LINES_V

Object Details

Object Name:	AR_XLA_ARD_RA_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_XLA_ARD_RA_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
LINE_ID	NUMBER	(15)	Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger
SOURCE_ID	NUMBER	(15)	Identifier for record in SOURCE_TABLE that created this distribution.
SOURCE_TABLE	VARCHAR2	(10)	Possible values are CRH for the AR_CASH_RECEIPT_HISTORY_ALL table, RA for the AR_RECEIVABLE_APPLICATIONS_ALL table, ADJ for the AR_ADJUSTMENTS_ALL table, MCD for the AR_MISC_CASH_DISTRIBUTIONS_ALL table, or TH for the AR_TRANSACTION_HISTORY_ALL table.
SOURCE_TYPE	VARCHAR2	(30)	Account type of transaction for which distribution is posted.
GL_SL_LINK_ID	VARCHAR2	(0)
GL_SL_LINK_TABLE	VARCHAR2	(0)
CODE_COMBINATION_ID	NUMBER	(15)
AMOUNT_DR	NUMBER
AMOUNT_CR	NUMBER
ACCTD_AMOUNT_DR	NUMBER
ACCTD_AMOUNT_CR	NUMBER
ORG_ID	NUMBER	(15)
SOURCE_TABLE_SECONDARY	VARCHAR2	(10)
SOURCE_ID_SECONDARY	NUMBER	(15)
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_CONVERSION_DATE	DATE
TAXABLE_ENTERED_DR	NUMBER
TAXABLE_ENTERED_CR	NUMBER
TAXABLE_ACCOUNTED_DR	NUMBER
TAXABLE_ACCOUNTED_CR	NUMBER
TAX_LINK_ID	NUMBER	(15)
THIRD_PARTY_ID	NUMBER	(15)
THIRD_PARTY_SUB_ID	NUMBER	(15)
REVERSED_SOURCE_ID	NUMBER	(15)
TAX_CODE_ID	NUMBER	(15)
LOCATION_SEGMENT_ID	NUMBER	(15)
SOURCE_TYPE_SECONDARY	VARCHAR2	(30)
TAX_GROUP_CODE_ID	NUMBER	(15)
REF_CUSTOMER_TRX_LINE_ID	NUMBER	(15)
REF_CUST_TRX_LINE_GL_DIST_ID	NUMBER	(15)
REF_LINE_ID	NUMBER	(15)
FROM_AMOUNT_DR	NUMBER
FROM_AMOUNT_CR	NUMBER
FROM_ACCTD_AMOUNT_DR	NUMBER
FROM_ACCTD_AMOUNT_CR	NUMBER
REF_ACCOUNT_CLASS	VARCHAR2	(30)
ACTIVITY_BUCKET	VARCHAR2	(30)
REF_DIST_CCID	NUMBER	(15)
REF_MF_DIST_FLAG	VARCHAR2	(1)
AE_HEADER_ID	NUMBER
GL_DATE	DATE
GL_POSTED_DATE	VARCHAR2	(0)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
AE_LINE_NUM	NUMBER
CASH_RECEIPT_ID	NUMBER	(15)
APPLICATION_TYPE	VARCHAR2	(20)
POSTING_CONTROL_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      SOURCE_TYPE
,      GL_SL_LINK_ID
,      GL_SL_LINK_TABLE
,      CODE_COMBINATION_ID
,      AMOUNT_DR
,      AMOUNT_CR
,      ACCTD_AMOUNT_DR
,      ACCTD_AMOUNT_CR
,      ORG_ID
,      SOURCE_TABLE_SECONDARY
,      SOURCE_ID_SECONDARY
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      TAXABLE_ENTERED_DR
,      TAXABLE_ENTERED_CR
,      TAXABLE_ACCOUNTED_DR
,      TAXABLE_ACCOUNTED_CR
,      TAX_LINK_ID
,      THIRD_PARTY_ID
,      THIRD_PARTY_SUB_ID
,      REVERSED_SOURCE_ID
,      TAX_CODE_ID
,      LOCATION_SEGMENT_ID
,      SOURCE_TYPE_SECONDARY
,      TAX_GROUP_CODE_ID
,      REF_CUSTOMER_TRX_LINE_ID
,      REF_CUST_TRX_LINE_GL_DIST_ID
,      REF_LINE_ID
,      FROM_AMOUNT_DR
,      FROM_AMOUNT_CR
,      FROM_ACCTD_AMOUNT_DR
,      FROM_ACCTD_AMOUNT_CR
,      REF_ACCOUNT_CLASS
,      ACTIVITY_BUCKET
,      REF_DIST_CCID
,      REF_MF_DIST_FLAG
,      AE_HEADER_ID
,      GL_DATE
,      GL_POSTED_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      AE_LINE_NUM
,      CASH_RECEIPT_ID
,      APPLICATION_TYPE
,      POSTING_CONTROL_ID
FROM APPS.AR_XLA_ARD_RA_LINES_V;

Dependencies

[top of page]

APPS.AR_XLA_ARD_RA_LINES_V references the following:

APPS: AR_DISTRIBUTIONS_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; XLA_DISTRIBUTION_LINKS

APPS.AR_XLA_ARD_RA_LINES_V is not referenced by any database object