PJF_BU_IMPL_ALL
PA_IMPLEMENTATIONS_ALL stores the parameters and defaults that define the configuration of your Oracle Projects installation. . If you have a multi-organization installation, you define one row for each operating unit.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_BU_IMPL_ALL_PK |
ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PROJ_TREE_VERSION_ID | VARCHAR2 | 32 | Yes | PROJ_TREE_VERSION_ID | |
| EXP_TREE_VERSION_ID | VARCHAR2 | 32 | Yes | EXP_TREE_VERSION_ID | |
| SEPARATION_OF_DUTIES_FLAG | VARCHAR2 | 1 | SEPARATION_OF_DUTIES_FLAG | ||
| EXP_TREE_STRUCTURE_CODE | VARCHAR2 | 30 | Yes | EXP_TREE_STRUCTURE_CODE | |
| PROJ_TREE_STRUCTURE_CODE | VARCHAR2 | 30 | Yes | PROJ_TREE_STRUCTURE_CODE | |
| RET_PROCESS_FLAG | VARCHAR2 | 1 | Check box value that when selected enables retirement cost processing features for the business unit. | ||
| PA_PERIOD_TYPE | VARCHAR2 | 15 | Yes | The GL period type that identifies the PA periods associated with the ledger in the GL calendar. | |
| 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. | ||
| EXP_CYCLE_START_DAY_CODE | VARCHAR2 | 30 | Yes | The code for the week day on which the expenditure week period begins. This value determines the valid expenditure ending dates for expenditure groups, expenditures, and labor cost rates | |
| OVERTIME_CALC_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether the Overtime Calculation program is enabled. If the program is enabled, Distribute Labor Costs will run the Overtime Calculation program | |
| EXP_TREE_CODE | VARCHAR2 | 30 | Yes | EXP_TREE_CODE | |
| EXP_START_ORG_ID | NUMBER | 18 | Yes | Identifier of the highest organization used in expenditure organization hierarchy version | |
| PROJ_TREE_CODE | VARCHAR2 | 30 | PROJ_TREE_CODE | ||
| PROJ_START_ORG_ID | NUMBER | 18 | Yes | Identifier of the highest organization used in project organization hierarchy version | |
| CC_PROCESS_IO_CODE | VARCHAR2 | 1 | Indicates whether to perform cross charge processing for intra-operating unit (IO) transactions, which are within the same operating unit but not the same provider and receiver organization. | ||
| CC_DEFAULT_RATE_TYPE | VARCHAR2 | 30 | Default rate type to be used when converting the transfer price from the transaction currency to the functional currency of the provider operating unit. | ||
| CC_DEFAULT_RATE_DATE_CODE | VARCHAR2 | 1 | Default rate date code to be used when converting the transfer price from the transaction currency to the functional currency. | ||
| CC_ALLOW_IU_FLAG | VARCHAR2 | 1 | Indicates if the operating unit may incur inter-operating unit (IU) cross charge within the legal entity - Obsolete | ||
| CC_PROCESS_IU_CODE | VARCHAR2 | 1 | Indicates if the operating unit may incur inter operating (IU) cross charge within the legal entity | ||
| PERIOD_SET_NAME | VARCHAR2 | 15 | Calendar name.. | ||
| SAME_PA_GL_PERIOD | VARCHAR2 | 1 | Defines whether users will use a comon period definition for PA GL periods. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Default Corporate Asset Book identifier. | ||
| 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. | |
| DEF_SUPPLIER_COST_CR_CCID | NUMBER | 18 | Default Supplier Cost Credit Account - Obsolete | ||
| DEFAULT_RATE_DATE_CODE | VARCHAR2 | 1 | Indicates the code used to derive default rate dates. | ||
| DEFAULT_RATE_TYPE | VARCHAR2 | 30 | Default value for rate type |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_BU_IMPL_ALL | fa_book_controls | BOOK_TYPE_CODE |
| pjc_xcc_burden_dists | pjf_bu_impl_all | BUSINESS_UNIT_ID |
| pjf_periods_close_tmp | pjf_bu_impl_all | INVENTORY_ORG_ID |
| pjc_cc_prj_bu_relationships | pjf_bu_impl_all | BU_ID |
| pjf_event_type_ous_all | pjf_bu_impl_all | ORG_ID |
| pjf_pu_bu_relationship | pjf_bu_impl_all | ORG_ID |
| pjf_exp_type_ous_all | pjf_bu_impl_all | ORG_ID |
| pjc_commitment_txns | pjf_bu_impl_all | BU_ID |
| pjf_periods_all | pjf_bu_impl_all | ORG_ID |
| pjo_plan_type_rate_schs | pjf_bu_impl_all | BU_ID |
| pjc_exp_items_all | pjf_bu_impl_all | RECVR_ORG_ID |
| pjc_cc_org_relationships | pjf_bu_impl_all | PRVDR_BU_ID |
| pjc_cc_org_relationships | pjf_bu_impl_all | RECVR_BU_ID |
| pjc_cost_dist_lines_all | pjf_bu_impl_all | ORG_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_BU_IMPL_ALL_U1 | Unique | Default | ORG_ID |