PJO_PLAN_LINE_DETAILS
This table is used to store the plan line details of a plan version.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PJO_PLAN_LINE_DETAILS_PK |
PLAN_LINE_DETAIL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PLAN_LINE_DETAIL_ID | NUMBER | 18 | Yes | PLAN_LINE_DETAIL_ID ***** | |
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. | |
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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
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. | |
PLANNING_ELEMENT_ID | NUMBER | 18 | Yes | PLANNING_ELEMENT_ID ***** | |
TXN_CURRENCY_CODE | VARCHAR2 | 15 | Yes | The transaction currency code of the amount | |
START_DATE | DATE | Yes | The start date of the budget line | ||
END_DATE | DATE | Yes | The end date of the budget line | ||
PERIOD_NAME | VARCHAR2 | 30 | The period of the budget line | ||
PLAN_VERSION_ID | NUMBER | 18 | Yes | PLAN_VERSION_ID ***** | |
QUANTITY | NUMBER | The quantity of the budget line | |||
TC_RAW_COST | NUMBER | TC_RAW_COST ***** | |||
TC_BRDND_COST | NUMBER | TC_BRDND_COST ***** | |||
TC_REVENUE | NUMBER | TC_REVENUE ***** | |||
PFC_CODE | VARCHAR2 | 15 | PFC_CODE ***** | ||
PFC_RAW_COST | NUMBER | PFC_RAW_COST ***** | |||
PFC_BRDND_COST | NUMBER | PFC_BRDND_COST ***** | |||
PFC_REVENUE | NUMBER | PFC_REVENUE ***** | |||
PC_RAW_COST | NUMBER | PC_RAW_COST ***** | |||
PC_CODE | VARCHAR2 | 15 | PC_CODE ***** | ||
PC_BRDND_COST | NUMBER | PC_BRDND_COST ***** | |||
PC_REVENUE | NUMBER | PC_REVENUE ***** | |||
ACT_QUANTITY | NUMBER | ACT_QUANTITY ***** | |||
TC_ACT_RAW_COST | NUMBER | TC_ACT_RAW_COST ***** | |||
TC_ACT_BRDND_COST | NUMBER | TC_ACT_BRDND_COST ***** | |||
TC_ACT_REVENUE | NUMBER | TC_ACT_REVENUE ***** | |||
PFC_ACT_RAW_COST | NUMBER | PFC_ACT_RAW_COST ***** | |||
PFC_ACT_BRDND_COST | NUMBER | PFC_ACT_BRDND_COST ***** | |||
PFC_ACT_REVENUE | NUMBER | PFC_ACT_REVENUE ***** | |||
PC_ACT_RAW_COST | NUMBER | PC_ACT_RAW_COST ***** | |||
PC_ACT_BRDND_COST | NUMBER | PC_ACT_BRDND_COST ***** | |||
PC_ACT_REVENUE | NUMBER | PC_ACT_REVENUE ***** | |||
TC_STD_RAW_COST_RATE | NUMBER | TC_STD_RAW_COST_RATE ***** | |||
TC_RAW_COST_RATE_OVERRIDE | NUMBER | TC_RAW_COST_RATE_OVERRIDE ***** | |||
TC_STD_BRDND_COST_RATE | NUMBER | TC_STD_BRDND_COST_RATE ***** | |||
TC_BRDND_COST_RATE_OVERRIDE | NUMBER | TC_BRDND_COST_RATE_OVERRIDE ***** | |||
TC_STD_BILL_RATE | NUMBER | TC_STD_BILL_RATE ***** | |||
TC_BILL_RATE_OVERRIDE | NUMBER | TC_BILL_RATE_OVERRIDE ***** | |||
TC_MARKUP_PERCENT | NUMBER | TC_MARKUP_PERCENT ***** | |||
TC_MARKUP_PERCENT_OVERRIDE | NUMBER | TC_MARKUP_PERCENT_OVERRIDE ***** | |||
PFC_COST_RATE_TYPE | VARCHAR2 | 30 | PFC_COST_RATE_TYPE ***** | ||
PFC_COST_EXCHANGE_RATE | NUMBER | PFC_COST_EXCHANGE_RATE ***** | |||
PFC_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | PFC_COST_RATE_DATE_TYPE ***** | ||
PFC_COST_RATE_DATE | DATE | PFC_COST_RATE_DATE ***** | |||
PFC_REV_RATE_TYPE | VARCHAR2 | 30 | PFC_REV_RATE_TYPE ***** | ||
PFC_REV_EXCHANGE_RATE | NUMBER | PFC_REV_EXCHANGE_RATE ***** | |||
PFC_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | PFC_REV_RATE_DATE_TYPE ***** | ||
PFC_REV_RATE_DATE | DATE | PFC_REV_RATE_DATE ***** | |||
PC_COST_RATE_TYPE | VARCHAR2 | 30 | PC_COST_RATE_TYPE ***** | ||
PC_COST_EXCHANGE_RATE | NUMBER | PC_COST_EXCHANGE_RATE ***** | |||
PC_COST_RATE_DATE_TYPE | VARCHAR2 | 30 | PC_COST_RATE_DATE_TYPE ***** | ||
PC_COST_RATE_DATE | DATE | PC_COST_RATE_DATE ***** | |||
PC_REV_RATE_TYPE | VARCHAR2 | 30 | PC_REV_RATE_TYPE ***** | ||
PC_REV_EXCHANGE_RATE | NUMBER | PC_REV_EXCHANGE_RATE ***** | |||
PC_REV_RATE_DATE_TYPE | VARCHAR2 | 30 | PC_REV_RATE_DATE_TYPE ***** | ||
PC_REV_RATE_DATE | DATE | PC_REV_RATE_DATE ***** | |||
REQ_QUANTITY | NUMBER | REQ_QUANTITY ***** | |||
TC_REQ_RAW_COST | NUMBER | TC_REQ_RAW_COST ***** | |||
TC_REQ_BRDND_COST | NUMBER | TC_REQ_BRDND_COST ***** | |||
PC_REQ_RAW_COST | NUMBER | PC_REQ_RAW_COST ***** | |||
PC_REQ_BRDND_COST | NUMBER | PC_REQ_BRDND_COST ***** | |||
PFC_REQ_RAW_COST | NUMBER | PFC_REQ_RAW_COST ***** | |||
PFC_REQ_BRDND_COST | NUMBER | PFC_REQ_BRDND_COST ***** | |||
PO_QUANTITY | NUMBER | PO_QUANTITY ***** | |||
TC_PO_RAW_COST | NUMBER | TC_PO_RAW_COST ***** | |||
TC_PO_BRDND_COST | NUMBER | TC_PO_BRDND_COST ***** | |||
PC_PO_RAW_COST | NUMBER | PC_PO_RAW_COST ***** | |||
PC_PO_BRDND_COST | NUMBER | PC_PO_BRDND_COST ***** | |||
PFC_PO_RAW_COST | NUMBER | PFC_PO_RAW_COST ***** | |||
PFC_PO_BRDND_COST | NUMBER | PFC_PO_BRDND_COST ***** | |||
SI_QUANTITY | NUMBER | SI_QUANTITY ***** | |||
TC_SI_RAW_COST | NUMBER | TC_SI_RAW_COST ***** | |||
TC_SI_BRDND_COST | NUMBER | TC_SI_BRDND_COST ***** | |||
PC_SI_RAW_COST | NUMBER | PC_SI_RAW_COST ***** | |||
PC_SI_BRDND_COST | NUMBER | PC_SI_BRDND_COST ***** | |||
PFC_SI_RAW_COST | NUMBER | PFC_SI_RAW_COST ***** | |||
PFC_SI_BRDND_COST | NUMBER | PFC_SI_BRDND_COST ***** | |||
EXT_QUANTITY | NUMBER | EXT_QUANTITY ***** | |||
TC_EXT_RAW_COST | NUMBER | TC_EXT_RAW_COST ***** | |||
TC_EXT_BRDND_COST | NUMBER | TC_EXT_BRDND_COST ***** | |||
PC_EXT_RAW_COST | NUMBER | PC_EXT_RAW_COST ***** | |||
PC_EXT_BRDND_COST | NUMBER | PC_EXT_BRDND_COST ***** | |||
PFC_EXT_RAW_COST | NUMBER | PFC_EXT_RAW_COST ***** | |||
PFC_EXT_BRDND_COST | NUMBER | PFC_EXT_BRDND_COST ***** | |||
COST_IND_COMPILED_SET_ID | NUMBER | 18 | The identifier of the compiled set that is used to calculate the cost amount of the expenditure item | ||
MULTI_ERROR_FLAG | VARCHAR2 | 1 | MULTI_ERROR_FLAG ***** | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
TC_STD_BRDND_MULTIPLIER | NUMBER | TC_STD_BRDND_MULTIPLIER ***** | |||
COST_RATE_SCHEDULE_ID | NUMBER | 18 | COST_RATE_SCHEDULE_ID ***** | ||
BILL_RATE_SCHEDULE_ID | NUMBER | 18 | BILL_RATE_SCHEDULE_ID ***** | ||
IND_RATE_SCHEDULE_ID | NUMBER | 18 | IND_RATE_SCHEDULE_ID ***** | ||
RATE_UPDATED_DATE | TIMESTAMP | Used to Track The Date When rate computation happened for the resource | |||
PM_SOURCE_REFERENCE | VARCHAR2 | 25 | Identifier of the budget line detail in the source application from which the budget was imported. | ||
AWARD_PERIOD_ID | NUMBER | 18 | Award Period Identifier | ||
PROCESS_FLAG | VARCHAR2 | 1 | A flag to indicate whether or not to process the planning amount details. | ||
ADDL_ATTRIBUTE_NUM_1 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_2 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_3 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_4 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_5 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_6 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_7 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_8 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_9 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_10 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_VAR_1 | VARCHAR2 | 30 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_2 | VARCHAR2 | 30 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_3 | VARCHAR2 | 30 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_4 | VARCHAR2 | 80 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_5 | VARCHAR2 | 80 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_6 | VARCHAR2 | 80 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_7 | VARCHAR2 | 240 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_8 | VARCHAR2 | 240 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_9 | VARCHAR2 | 240 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_VAR_10 | VARCHAR2 | 240 | Oracle internal use only. | ||
ADDL_ATTRIBUTE_DATE_1 | DATE | Oracle internal use only. | |||
ADDL_ATTRIBUTE_DATE_2 | DATE | Oracle internal use only. | |||
ADDL_ATTRIBUTE_DATE_3 | DATE | Oracle internal use only. | |||
ADDL_ATTRIBUTE_DATE_4 | DATE | Oracle internal use only. | |||
ADDL_ATTRIBUTE_DATE_5 | DATE | Oracle internal use only. | |||
TO_QUANTITY | NUMBER | Effort in hours associated with transfer orders. | |||
TC_TO_RAW_COST | NUMBER | Raw cost associated with transfer orders in transaction currency. | |||
TC_TO_BRDND_COST | NUMBER | Burdened cost associated with transfer orders in transaction currency. | |||
PC_TO_RAW_COST | NUMBER | Raw cost associated with transfer orders in project currency. | |||
PC_TO_BRDND_COST | NUMBER | Burdened cost associated with transfer orders in project currency. | |||
PFC_TO_RAW_COST | NUMBER | Raw cost associated with transfer orders in project ledger currency. | |||
PFC_TO_BRDND_COST | NUMBER | Burdened cost associated with transfer orders in project ledger currency. | |||
RCPT_QUANTITY | NUMBER | Effort in hours associated with receipts. | |||
TC_RCPT_RAW_COST | NUMBER | Raw cost associated with receipts in transaction currency. | |||
TC_RCPT_BRDND_COST | NUMBER | Burdened cost associated with receipts in transaction currency. | |||
PC_RCPT_RAW_COST | NUMBER | Raw cost associated with receipts in project currency. | |||
PC_RCPT_BRDND_COST | NUMBER | Burdened cost associated with receipts in project currency. | |||
PFC_RCPT_RAW_COST | NUMBER | Raw cost associated with receipts in project ledger currency. | |||
PFC_RCPT_BRDND_COST | NUMBER | Burdened cost associated with receipts in project ledger currency. | |||
ADDL_ATTRIBUTE_NUM_11 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_12 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_13 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_14 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_15 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_16 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_17 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_18 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_19 | NUMBER | Oracle internal use only. | |||
ADDL_ATTRIBUTE_NUM_20 | NUMBER | Oracle internal use only. | |||
MANUAL_SPREAD_FLAG | VARCHAR2 | 1 | Indicates whether system spread has been modified by user. | ||
LAST_COSTED_DATE | DATE | Date on which the costing process was last run and the cost measures of the plan line detail were derived. If costs are recalculated in working plan versions for existing plan lines, then this date is incremented accordingly. | |||
COST_RATE_OVERRIDE_ID | NUMBER | 18 | Unique identifier of any project cost rate override that was derived during the last run of the costing process. | ||
COMP_DETAILS_ID | NUMBER | 18 | Unique identifier of any labor costing override that was derived during the last run of the costing process. | ||
ORG_COSTING_RULE_ID | NUMBER | 18 | Unique identifier of any organization costing rule that was derived during the last run of the costing process. | ||
COST_SCHEDULE_LINE_ID | NUMBER | 18 | Unique identifier of any rate schedule line that was derived during the last run of the costing process. | ||
PFC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in project ledger currency. | |||
PC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in project currency. | |||
TC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in transaction currency. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PJO_PLAN_LINE_DETAILS | pjo_plan_versions_b | PLAN_VERSION_ID |
PJO_PLAN_LINE_DETAILS | pjo_planning_elements | PLANNING_ELEMENT_ID |
pjo_errors | pjo_plan_line_details | PLAN_LINE_DETAIL_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJO_PLAN_LINE_DETAILS_N1 | Non Unique | Default | PLAN_VERSION_ID, START_DATE |
PJO_PLAN_LINE_DETAILS_N2 | Non Unique | Default | LAST_UPDATE_DATE |
PJO_PLAN_LINE_DETAILS_N3 | Non Unique | Default | PLANNING_ELEMENT_ID, TXN_CURRENCY_CODE, START_DATE |
PJO_PLAN_LINE_DETAILS_N4 | Non Unique | Default | AWARD_PERIOD_ID |
PJO_PLAN_LINE_DETAILS_N5 | Non Unique | Default | PLAN_VERSION_ID, PLANNING_ELEMENT_ID, TXN_CURRENCY_CODE |
PJO_PLAN_LINE_DETAILS_U1 | Unique | Default | PLAN_LINE_DETAIL_ID |