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]

TABLE: AP.AP_EXP_REPORT_DISTS_ALL

Object Details

Object Name:	AP_EXP_REPORT_DISTS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_EXP_REPORT_DISTS_ALL
Subobject Name:
Status:	VALID

This table is used to store distribution information for a specific expense line. The table is a multi-org table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_EXP_REPORT_DISTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPORT_DISTRIBUTION_ID
AP_EXP_REPORT_DISTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_HEADER_ID REPORT_LINE_ID
AP_EXP_REPORT_DISTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_LINE_ID
AP_EXP_REPORT_DISTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_HEADER_ID	NUMBER		Yes	Report Header Identifier.
REPORT_LINE_ID	NUMBER	(15)	Yes	Report Line Identifier.
REPORT_DISTRIBUTION_ID	NUMBER	(15)	Yes	Report Distribution Identifier.
ORG_ID	NUMBER	(15)		The organization ID.
SEQUENCE_NUM	NUMBER	(15)	Yes	Indicates display sequence number.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CODE_COMBINATION_ID	NUMBER	(15)		The GL Code Combination Id
SEGMENT1	VARCHAR2	(25)		Segment 1
SEGMENT2	VARCHAR2	(25)		Segment 2
SEGMENT3	VARCHAR2	(25)		Segment 3
SEGMENT4	VARCHAR2	(25)		Segment 4
SEGMENT5	VARCHAR2	(25)		Segment 5
SEGMENT6	VARCHAR2	(25)		Segment 6
SEGMENT7	VARCHAR2	(25)		Segment 7
SEGMENT8	VARCHAR2	(25)		Segment 8
SEGMENT9	VARCHAR2	(25)		Segment 9
SEGMENT10	VARCHAR2	(25)		Segment 10
SEGMENT11	VARCHAR2	(25)		Segment 11
SEGMENT12	VARCHAR2	(25)		Segment 12
SEGMENT13	VARCHAR2	(25)		Segment 13
SEGMENT14	VARCHAR2	(25)		Segment 14
SEGMENT15	VARCHAR2	(25)		Segment 15
SEGMENT16	VARCHAR2	(25)		Segment 16
SEGMENT17	VARCHAR2	(25)		Segment 17
SEGMENT18	VARCHAR2	(25)		Segment 18
SEGMENT19	VARCHAR2	(25)		Segment 19
SEGMENT20	VARCHAR2	(25)		Segment 20
SEGMENT21	VARCHAR2	(25)		Segment 21
SEGMENT22	VARCHAR2	(25)		Segment 22
SEGMENT23	VARCHAR2	(25)		Segment 23
SEGMENT24	VARCHAR2	(25)		Segment 24
SEGMENT25	VARCHAR2	(25)		Segment 25
SEGMENT26	VARCHAR2	(25)		Segment 26
SEGMENT27	VARCHAR2	(25)		Segment 27
SEGMENT28	VARCHAR2	(25)		Segment 28
SEGMENT29	VARCHAR2	(25)		Segment 29
SEGMENT30	VARCHAR2	(25)		Segment 30
PREPARER_MODIFIED_FLAG	VARCHAR2	(1)		This is used to identify whether the preparer has modified the expense allocations values when entering the expense report.
AMOUNT	NUMBER			Reimbursable amount.
PROJECT_ID	NUMBER	(15)		Project identifier for Oracle Projects.
TASK_ID	NUMBER	(15)		Task identifier for Oracle Projects.
AWARD_ID	NUMBER	(15)		Award identifier used to track grant information if Oracle Grants Accounting is installed.
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)		Organization identifier for Oracle Projects.
COST_CENTER	VARCHAR2	(25)		Cost Center.
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Indicates the code for the currency in which the expense was incurred.
RECEIPT_CONVERSION_RATE	NUMBER			The conversion rate between the receipt currency and the currency in which the expense report will be paid.
RECEIPT_CURRENCY_AMOUNT	NUMBER			The amount that appears on the receipt.
WEB_PARAMETER_ID	NUMBER			Holds the Expense Type on the line

Query Text

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


SELECT REPORT_HEADER_ID
,      REPORT_LINE_ID
,      REPORT_DISTRIBUTION_ID
,      ORG_ID
,      SEQUENCE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      PREPARER_MODIFIED_FLAG
,      AMOUNT
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      EXPENDITURE_ORGANIZATION_ID
,      COST_CENTER
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      RECEIPT_CURRENCY_AMOUNT
,      WEB_PARAMETER_ID
FROM AP.AP_EXP_REPORT_DISTS_ALL;

Dependencies

[top of page]

AP.AP_EXP_REPORT_DISTS_ALL does not reference any database object

AP.AP_EXP_REPORT_DISTS_ALL is referenced by following:

AP: AP_EXP_REPORT_DISTS_ALL#