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_FIN_PLAN_ADJ_LINES

Object Details

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

This table stores the adjustment lines for a Financial Plan

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FIN_PLAN_ADJ_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FIN_PLAN_ADJ_LINE_ID
PA__FIN_PLAN_ADJ_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
PA__FIN_PLAN_ADJ_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJ_ELEMENT_ID
PA__FIN_PLAN_ADJ_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ASSIGNMENT_ID START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
FIN_PLAN_ADJ_LINE_ID	NUMBER	(15)	Yes	The system generated number that uniquely identifies the adjustment line
ADJ_ELEMENT_ID	NUMBER	(15)	Yes	Identifier of adjustment element
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the Project that holds the plan version amounts
TASK_ID	NUMBER	(15)	Yes	The identifier of the task
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The identifier of the plan version
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)	Yes	The identifier of the resource assignment
PERIOD_NAME	VARCHAR2	(30)	Yes	The GL or PA period name to which the adjustment line belongs to
START_DATE	DATE		Yes	The start date of the period
END_DATE	DATE		Yes	The end date of the period
RAW_COST_ADJUSTMENT	NUMBER			The raw cost adjustment of the adjustment line
BURDENED_COST_ADJUSTMENT	NUMBER			The burdened cost adjustment of the adjustment line.
REVENUE_ADJUSTMENT	NUMBER			The revenue adjustment of the adjustment line
UTILIZATION_ADJUSTMENT	NUMBER			The utilization percent adjustment of the adjustment line
HEAD_COUNT_ADJUSTMENT	NUMBER			The head count adjustment of the adjustment line
ADJUSTMENT_COMMENTS	VARCHAR2	(240)		The adjustment comment of the adjustment line
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

Query Text

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


SELECT FIN_PLAN_ADJ_LINE_ID
,      ADJ_ELEMENT_ID
,      PROJECT_ID
,      TASK_ID
,      BUDGET_VERSION_ID
,      RESOURCE_ASSIGNMENT_ID
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      RAW_COST_ADJUSTMENT
,      BURDENED_COST_ADJUSTMENT
,      REVENUE_ADJUSTMENT
,      UTILIZATION_ADJUSTMENT
,      HEAD_COUNT_ADJUSTMENT
,      ADJUSTMENT_COMMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_FIN_PLAN_ADJ_LINES;

Dependencies

[top of page]

PA.PA_FIN_PLAN_ADJ_LINES does not reference any database object

PA.PA_FIN_PLAN_ADJ_LINES is referenced by following:

PA: PA_FIN_PLAN_ADJ_LINES#