1. Tables and Views for Project Management
  2. PJC_MC_PRJ_AST_LINE_DTLS

PJC_MC_PRJ_AST_LINE_DTLS

PJC_MC_PRJ_AST_LINE_DTLS is an MRC sub table of PJC_PRJ_ASSET_LN_DETS. It stores currency related information about project asset line details for each reporting set of books associated with the parent record on PJC_PRJ_ASSET_LN_DETS. The primary key on this table is: SET_OF_BOOKS_ID, PROJ_ASSET_LINE_DTL_UNIQ_ID.

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

PJC_MC_PRJ_AST_LINE_DTLS_PK

SET_OF_BOOKS_ID, PROJ_ASSET_LINE_DTL_UNIQ_ID

Columns

Name Datatype Length Precision Not-null Comments
SET_OF_BOOKS_ID NUMBER 18 Yes The reporting ledger unique identifier
PROJ_ASSET_LINE_DTL_UNIQ_ID NUMBER 18 Yes The system-generated number that uniquely identifies the detail asset line
PROJECT_ASSET_LINE_DETAIL_ID NUMBER 18 Yes The attribute relating detail records to asset lines
CIP_COST NUMBER Yes The cip cost amount in the reporting currency from the associated cost distribution line.
CURRENCY_CODE VARCHAR2 30 The currency code associated with the reporting ledger.
EXCHANGE_RATE NUMBER The exchange rate used to convert from the functional currency to the reporting currency on the conversion
CONVERSION_DATE DATE The conversion date on which the reporting currency amounts were converted.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
PJC_MC_PRJ_AST_LINE_DTLS pjc_prj_asset_ln_dets PROJ_ASSET_LINE_DTL_UNIQ_ID

Indexes

Index Uniqueness Tablespace Columns
PJC_MC_PRJ_AST_LINE_DTLS_U1 Unique Default SET_OF_BOOKS_ID, PROJ_ASSET_LINE_DTL_UNIQ_ID