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: PA.PA_COST_DIST_OVERRIDES

Object Details

Object Name:	PA_COST_DIST_OVERRIDES
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_COST_DIST_OVERRIDES
Subobject Name:
Status:	VALID

PA_COST_DIST_OVERRIDES stores configurations defined
at the project level that redirect specific costs and
revenue to another organization. You can define a
cost distribution override to redirect the costs and
revenues generated by a specific employee or by all
employees assigned to a specified organization. You
can optionally redirect only certain costs and
revenues by specifying an expenditure category.
The cost distribution programs store the destination
organization in the OVERRIDE_TO_ORGANIZATION_ID column
of the PA_EXPENDITURE_ITEMS_ALL table. The destination
organization overrides the organization that is
normally derived from the expenditure or from the
Expenditure Organization parameter that is passed to
AutoAccounting. The destination organization is
stored as the EXPENDITURE_ORGANIZATION_ID in the
project accumulator tables.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	3
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_COST_DIST_OVERRIDES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COST_DISTRIBUTION_OVERRIDE_ID
PA_COST_DIST_OVERRIDES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID OVERRIDE_FROM_ORGANIZATION_ID PERSON_ID EXPENDITURE_CATEGORY START_DATE_ACTIVE

Columns

Name	Datatype	Length	Mandatory	Comments
COST_DISTRIBUTION_OVERRIDE_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the cost distribution override
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project that is configured according to the cost distribution override
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the organization to which costs and revenue are overridden
START_DATE_ACTIVE	DATE		Yes	First effective date of the override
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)	Yes	Standard Who Column
PERSON_ID	NUMBER	(9)		The identifier of the employee for which costs and revenue are overridden
EXPENDITURE_CATEGORY	VARCHAR2	(30)		The expenditure category for which costs and revenue are overridden
OVERRIDE_FROM_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization for which costs and revenue are overridden
END_DATE_ACTIVE	DATE			Last effective date of the override

Query Text

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


SELECT COST_DISTRIBUTION_OVERRIDE_ID
,      PROJECT_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      START_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PERSON_ID
,      EXPENDITURE_CATEGORY
,      OVERRIDE_FROM_ORGANIZATION_ID
,      END_DATE_ACTIVE
FROM PA.PA_COST_DIST_OVERRIDES;

Dependencies

[top of page]

PA.PA_COST_DIST_OVERRIDES does not reference any database object

PA.PA_COST_DIST_OVERRIDES is referenced by following:

PA: PA_COST_DIST_OVERRIDES#