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

TABLE: PA.PA_MC_PRJ_AST_LINES_ALL

Object Details
Object Name: PA_MC_PRJ_AST_LINES_ALL
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_MC_PRJ_AST_LINES_ALL
Subobject Name:
Status: VALID


PA_MC_PRJ_AST_LINES_ALL is an MRC sub table of
PA_PROJECT_ASSET_LINES_ALL. It stores currency related information
about project asset lines for each reporting set of books associated
with the parent record on PA_PROJECT_ASSET_LINES_ALL. The primary
key on this table is: SET_OF_BOOKS_ID, PROJECT_ASSET_LINE_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_MC_PROJ_ASSET_LINES_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnPROJECT_ASSET_LINE_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes The reporting ledger unique identifier
PROJECT_ASSET_LINE_ID NUMBER (15) Yes The system-generated number that uniquely identifies the asset line
PROJECT_ASSET_LINE_DETAIL_ID NUMBER (15) Yes Identifier of the asset line details linking this line to cost distribution lines
ORIGINAL_ASSET_COST NUMBER

The cost amount in the reporting currency of the line at the time the line was originally created
CURRENT_ASSET_COST NUMBER

The line"s current cost amount in the reporting currency; split lines have a current cost <> original cost
Query Text

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


SELECT SET_OF_BOOKS_ID
,      PROJECT_ASSET_LINE_ID
,      PROJECT_ASSET_LINE_DETAIL_ID
,      ORIGINAL_ASSET_COST
,      CURRENT_ASSET_COST
FROM PA.PA_MC_PRJ_AST_LINES_ALL;

Dependencies

[top of page]

PA.PA_MC_PRJ_AST_LINES_ALL does not reference any database object

PA.PA_MC_PRJ_AST_LINES_ALL is referenced by following:

SchemaPA
ViewPA_MC_PRJ_AST_LINES_ALL#