1. Tables and Views for Project Management
  2. PJC_MC_PRJ_AST_LINES_ALL

PJC_MC_PRJ_AST_LINES_ALL

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

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

PJC_MC_PRJ_AST_LINES_ALL_PK

SET_OF_BOOKS_ID, PROJECT_ASSET_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
SET_OF_BOOKS_ID NUMBER 18 Yes The reporting ledger unique identifier
PROJECT_ASSET_LINE_ID NUMBER 18 Yes The system-generated number that uniquely identifies the asset line
PROJECT_ASSET_LINE_DETAIL_ID NUMBER 18 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
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.

Foreign Keys

Table Foreign Table Foreign Key Column
PJC_MC_PRJ_AST_LINES_ALL pjc_prj_asset_lns_all PROJECT_ASSET_LINE_ID

Indexes

Index Uniqueness Tablespace Columns
PJC_MC_PRJ_AST_LINES_ALL_U1 Unique Default SET_OF_BOOKS_ID, PROJECT_ASSET_LINE_ID