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

TABLE: AP.AP_EXP_REPORT_DISTS_ARC

Object Details
Object Name: AP_EXP_REPORT_DISTS_ARC
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_EXP_REPORT_DISTS_ARC
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ARC_REQ_ID NUMBER
Yes Archive Request Identifier
ARCHIVE_DATE DATE

Archive Date - Date when this row was created.
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)
Organization Identifier
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 Identifier
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 11
SEGMENT13 VARCHAR2 (25)
Segment 11
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 line was incurred
RECEIPT_CONVERSION_RATE NUMBER

The user-defined 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 ARC_REQ_ID
,      ARCHIVE_DATE
,      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_ARC;

Dependencies

[top of page]

AP.AP_EXP_REPORT_DISTS_ARC does not reference any database object

AP.AP_EXP_REPORT_DISTS_ARC is referenced by following:

SchemaAP
ViewAP_EXP_REPORT_DISTS_ARC#