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_LINES_V

Object Details

Object Name:	AR_XLA_ARD_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.AR_XLA_ARD_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
LINE_ID	NUMBER	(15)
SOURCE_ID	NUMBER	(15)
SOURCE_TABLE	VARCHAR2	(10)
SOURCE_TYPE	VARCHAR2	(30)
GL_SL_LINK_ID	NUMBER
GL_SL_LINK_TABLE	VARCHAR2	(30)
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
CASH_RECEIPT_ID	NUMBER
GL_DATE	DATE
GL_POSTED_DATE	DATE
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
AE_LINE_NUM	NUMBER

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
,      CASH_RECEIPT_ID
,      GL_DATE
,      GL_POSTED_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      AE_LINE_NUM
FROM APPS.AR_XLA_ARD_LINES_V;