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_PROJECT_ASSET_LINE_DETAILS

Object Details

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

PA_PROJECT_ASSET_LINE_DETAILS stores information
necessary to drill down from an asset line to the
cost distribution lines that are summarized in the
asset line. The table has no primary key.
When an asset line is initially created, this
table contains one record for each cost distribution line
summarized into the asset line. Each of these initial records
has the same PROJECT_ASSET_LINE_DETAIL_ID, which corresponds
to the PROJECT_ASSET_LINE_DETAIL_ID on the asset line.
When an asset line is split into multiple lines,
the PROJECT_ASSET_LINE_DETAIL_ID is copied to the new split
lines. This makes it possible to drill down from each split
line to all of the details supporting the original (pre-
split) line.
When an asset line is reversed, the
PA_PROJECT_ASSET_LINE_DETAILS reversal flag is set to 'Y'
for each associated detail line. Setting this flag to 'Y'
makes the associated cost distribution line now available
to be summarized into a new asset line, while maintaining
the ability to drill down from the reversed asset line to
its cost distribution lines.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_ASSET_LINE_DTLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJ_ASSET_LINE_DTL_UNIQ_ID
PA_PROJECT_ASSET_LINE_DET_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ASSET_LINE_DETAIL_ID
PA_PROJ_ASSET_LINE_DET_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID LINE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	The identifier of the expenditure item summarized into the asset line
LINE_NUM	NUMBER	(15)	Yes	The identifier of the cost distribution line summarized into the asset line
PROJECT_ASSET_LINE_DETAIL_ID	NUMBER	(15)	Yes	The attribute relating detail records to asset lines
CIP_COST	NUMBER	(22)	Yes	The cip cost amount from the associated cost distribution line.
REVERSED_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether or not the related asset line has been reversed.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
PROJ_ASSET_LINE_DTL_UNIQ_ID	NUMBER	(15)	Yes	Identifier of the Project asset line details

Query Text

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


SELECT EXPENDITURE_ITEM_ID
,      LINE_NUM
,      PROJECT_ASSET_LINE_DETAIL_ID
,      CIP_COST
,      REVERSED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJ_ASSET_LINE_DTL_UNIQ_ID
FROM PA.PA_PROJECT_ASSET_LINE_DETAILS;

Dependencies

[top of page]

PA.PA_PROJECT_ASSET_LINE_DETAILS does not reference any database object

PA.PA_PROJECT_ASSET_LINE_DETAILS is referenced by following:

APPS: PA_PROJECT_ASSET_LINE_DETAILS