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: AR.RA_INTERFACE_DISTRIBUTIONS_AL#

Object Details

Object Name:	RA_INTERFACE_DISTRIBUTIONS_AL#
Object Type:	VIEW
Owner:	AR
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_DISTRIBUTION_ID	NUMBER	(15)
INTERFACE_LINE_ID	NUMBER	(15)
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)
INTERFACE_LINE_ATTRIBUTE1	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE2	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE3	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE4	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE5	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE6	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE7	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE8	VARCHAR2	(150)
ACCOUNT_CLASS	VARCHAR2	(20)	Yes
AMOUNT	NUMBER
PERCENT	NUMBER
INTERFACE_STATUS	VARCHAR2	(1)
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CODE_COMBINATION_ID	NUMBER	(15)
SEGMENT1	VARCHAR2	(25)		Key flexfield segment
SEGMENT2	VARCHAR2	(25)		Key flexfield segment
SEGMENT3	VARCHAR2	(25)		Key flexfield segment
SEGMENT4	VARCHAR2	(25)		Key flexfield segment
SEGMENT5	VARCHAR2	(25)		Key flexfield segment
SEGMENT6	VARCHAR2	(25)		Key flexfield segment
SEGMENT7	VARCHAR2	(25)		Key flexfield segment
SEGMENT8	VARCHAR2	(25)		Key flexfield segment
SEGMENT9	VARCHAR2	(25)		Key flexfield segment
SEGMENT10	VARCHAR2	(25)		Key flexfield segment
SEGMENT11	VARCHAR2	(25)		Key flexfield segment
SEGMENT12	VARCHAR2	(25)		Key flexfield segment
SEGMENT13	VARCHAR2	(25)		Key flexfield segment
SEGMENT14	VARCHAR2	(25)		Key flexfield segment
SEGMENT15	VARCHAR2	(25)		Key flexfield segment
SEGMENT16	VARCHAR2	(25)		Key flexfield segment
SEGMENT17	VARCHAR2	(25)		Key flexfield segment
SEGMENT18	VARCHAR2	(25)		Key flexfield segment
SEGMENT19	VARCHAR2	(25)		Key flexfield segment
SEGMENT20	VARCHAR2	(25)		Key flexfield segment
SEGMENT21	VARCHAR2	(25)
SEGMENT22	VARCHAR2	(25)
SEGMENT23	VARCHAR2	(25)
SEGMENT24	VARCHAR2	(25)
SEGMENT25	VARCHAR2	(25)
SEGMENT26	VARCHAR2	(25)
SEGMENT27	VARCHAR2	(25)
SEGMENT28	VARCHAR2	(25)
SEGMENT29	VARCHAR2	(25)
SEGMENT30	VARCHAR2	(25)
COMMENTS	VARCHAR2	(240)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ACCTD_AMOUNT	NUMBER
INTERFACE_LINE_ATTRIBUTE10	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE11	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE12	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE13	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE14	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE15	VARCHAR2	(150)
INTERFACE_LINE_ATTRIBUTE9	VARCHAR2	(150)
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID	NUMBER	(15)		Organization identifier
INTERIM_TAX_CCID	NUMBER	(15)		Code combination ID for the interim tax account
INTERIM_TAX_SEGMENT1	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account.
INTERIM_TAX_SEGMENT2	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT3	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT4	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT5	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT6	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT7	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT8	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT9	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT10	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT11	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT12	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT13	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT14	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT15	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT16	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT17	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT18	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT19	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT20	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT21	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT22	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT23	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT24	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT25	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT26	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT27	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT28	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT29	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
INTERIM_TAX_SEGMENT30	VARCHAR2	(25)		Accounting Flexfield Segment for interim tax account
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
GLOBAL_ATTRIBUTE21	VARCHAR2	(150)
GLOBAL_ATTRIBUTE22	VARCHAR2	(150)
GLOBAL_ATTRIBUTE23	VARCHAR2	(150)
GLOBAL_ATTRIBUTE24	VARCHAR2	(150)
GLOBAL_ATTRIBUTE25	VARCHAR2	(150)
GLOBAL_ATTRIBUTE26	VARCHAR2	(150)
GLOBAL_ATTRIBUTE27	VARCHAR2	(150)
GLOBAL_ATTRIBUTE28	VARCHAR2	(150)
GLOBAL_ATTRIBUTE29	VARCHAR2	(150)
GLOBAL_ATTRIBUTE30	VARCHAR2	(150)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)

Query Text

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


SELECT INTERFACE_DISTRIBUTION_ID
,      INTERFACE_LINE_ID
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      ACCOUNT_CLASS
,      AMOUNT
,      PERCENT
,      INTERFACE_STATUS
,      REQUEST_ID
,      CODE_COMBINATION_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACCTD_AMOUNT
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      INTERFACE_LINE_ATTRIBUTE9
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      INTERIM_TAX_CCID
,      INTERIM_TAX_SEGMENT1
,      INTERIM_TAX_SEGMENT2
,      INTERIM_TAX_SEGMENT3
,      INTERIM_TAX_SEGMENT4
,      INTERIM_TAX_SEGMENT5
,      INTERIM_TAX_SEGMENT6
,      INTERIM_TAX_SEGMENT7
,      INTERIM_TAX_SEGMENT8
,      INTERIM_TAX_SEGMENT9
,      INTERIM_TAX_SEGMENT10
,      INTERIM_TAX_SEGMENT11
,      INTERIM_TAX_SEGMENT12
,      INTERIM_TAX_SEGMENT13
,      INTERIM_TAX_SEGMENT14
,      INTERIM_TAX_SEGMENT15
,      INTERIM_TAX_SEGMENT16
,      INTERIM_TAX_SEGMENT17
,      INTERIM_TAX_SEGMENT18
,      INTERIM_TAX_SEGMENT19
,      INTERIM_TAX_SEGMENT20
,      INTERIM_TAX_SEGMENT21
,      INTERIM_TAX_SEGMENT22
,      INTERIM_TAX_SEGMENT23
,      INTERIM_TAX_SEGMENT24
,      INTERIM_TAX_SEGMENT25
,      INTERIM_TAX_SEGMENT26
,      INTERIM_TAX_SEGMENT27
,      INTERIM_TAX_SEGMENT28
,      INTERIM_TAX_SEGMENT29
,      INTERIM_TAX_SEGMENT30
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      GLOBAL_ATTRIBUTE_CATEGORY
FROM AR.RA_INTERFACE_DISTRIBUTIONS_AL#;

Dependencies

[top of page]

AR.RA_INTERFACE_DISTRIBUTIONS_AL# references the following:

AR: RA_INTERFACE_DISTRIBUTIONS_ALL

AR.RA_INTERFACE_DISTRIBUTIONS_AL# is referenced by following:

APPS: RA_INTERFACE_DISTRIBUTIONS; RA_INTERFACE_DISTRIBUTIONS_ALL