PJC_CC_PRJ_BU_RELATIONSHIPS
PA_CC_PRJ_BU_RELATIONSHIPS stores the relationships between a project and cross chargeable or not cross chargeable operating units specified cross charge control and processing. The determining factor for whether the defined relationship is inclusive or exclusive is controlled by the allow_cross_charge_flag in table pjf_projects_all_b.allow_cross_charge_flag. When the flag is Y for the project then cross charge is allowed and any records in the table for that project will means excluded business units. When the flag is N for the project then cross charge is not allowed and any records in the table for that project will mean except for these business units.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_CC_PRJ_BU_RELATIONSHI_PK |
PROJECT_ID, BU_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the project ***** | |
| BU_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the business unit ***** | |
| EXCEPTION_FLAG | VARCHAR2 | 1 | Yes | This flag will either have I (Include) or E (Exclude). I means include the BUs and E means exclude the BUs. ***** | |
| 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. | |
| 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_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_CC_PRJ_BU_RELATIONSHIPS | pjf_projects_all_b | PROJECT_ID |
| PJC_CC_PRJ_BU_RELATIONSHIPS | pjf_bu_impl_all | BU_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_CC_PRJ_BU_RELATIONSHIPS_U1 | Unique | Default | PROJECT_ID, BU_ID |