PJC_PRJ_ASSET_LN_DETS

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.

Details

• Schema: FUSION

• Object owner: PJC

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PJC_PRJ_ASSET_LN_DETS_PK	PROJ_ASSET_LINE_DTL_UNIQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXPENDITURE_ITEM_ID	NUMBER		18	Yes	The identifier of the expenditure item summarized into the asset line
LINE_NUM	NUMBER		18	Yes	The identifier of the cost distribution line summarized into the 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 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	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PROJ_ASSET_LINE_DTL_UNIQ_ID	NUMBER		18	Yes	Identifier of the Project asset line details
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJC_PRJ_ASSET_LN_DETS	pjc_cost_dist_lines_all	EXPENDITURE_ITEM_ID, LINE_NUM
PJC_PRJ_ASSET_LN_DETS	pjc_prj_asset_lns_all	PROJECT_ASSET_LINE_DETAIL_ID
pjc_mc_prj_ast_line_dtls	pjc_prj_asset_ln_dets	PROJ_ASSET_LINE_DTL_UNIQ_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJC_PRJ_ASSET_LN_DETS_N1	Non Unique	Default	PROJECT_ASSET_LINE_DETAIL_ID
PJC_PRJ_ASSET_LN_DETS_N2	Non Unique	Default	EXPENDITURE_ITEM_ID, LINE_NUM
PJC_PRJ_ASSET_LN_DETS_N3	Non Unique	Default	REQUEST_ID
PJC_PRJ_ASSET_LN_DETS_U1	Unique	Default	PROJ_ASSET_LINE_DTL_UNIQ_ID