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

VIEW: APPS.APBV_EXP_REPORT_DISTS

Object Details
Object Name: APBV_EXP_REPORT_DISTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.APBV_EXP_REPORT_DISTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Based on AP_EXP_REPORT_DISTS_ALL, this view contains expense distribution data.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REPORT_DISTRIBUTION_ID NUMBER (15) Yes Report Distribution Identifier.
REPORT_LINE_ID NUMBER (15) Yes Report Line Identifier.
REPORT_HEADER_ID NUMBER
Yes Report Header 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.
CODE_COMBINATION_ID NUMBER (15)
The GL Code Combination Id
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.
Query Text

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


SELECT REPORT_DISTRIBUTION_ID
,      REPORT_LINE_ID
,      REPORT_HEADER_ID
,      ORG_ID
,      SEQUENCE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      CODE_COMBINATION_ID
,      PREPARER_MODIFIED_FLAG
,      AMOUNT
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      EXPENDITURE_ORGANIZATION_ID
,      COST_CENTER
FROM APPS.APBV_EXP_REPORT_DISTS;

Dependencies

[top of page]

APPS.APBV_EXP_REPORT_DISTS references the following:

SchemaAPPS
SynonymAP_EXP_REPORT_DISTS_ALL

APPS.APBV_EXP_REPORT_DISTS is not referenced by any database object