1. Tables and Views for Sales and Fusion Service
  2. JTF_RS_REP_MANAGERS

JTF_RS_REP_MANAGERS

Denormalized table that stores the reporting hierarchy of group members

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

JTF_RS_REP_MANAGERS_PK

DENORM_MGR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DENORM_MGR_ID NUMBER 18 Yes Unique identifier for denorm record
TREE_STRUCTURE_CODE VARCHAR2 30 Tree structure code of the resource organization hierarchy. FK to FND_TREE_STRUCTURE.TREE_STRUCTURE_CODE
TREE_CODE VARCHAR2 30 Tree code of the resource organization hierarchy. FK to FND_TREE.TREE_CODE
TREE_VERSION_ID VARCHAR2 32 Tree version id of the resource organization hierarchy. FK to FND_TREE_VERSION.TREE_VERSION_ID
RESOURCE_ID NUMBER 18 Yes Identifier for the resource member party. Foreign key to the HZ_PARTIES.PARTY_ID. Active
GROUP_ID NUMBER 18 Yes The group identifier to which this record refers to Active
PARENT_ORG_ID NUMBER 18 The organization identifier to which the parent resource refers to
HIERARCHY_TYPE VARCHAR2 30 Yes the hierarchy type ( refers to fnd_lookups where looup type is JTF_RS_HIERARCHY Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REPORTS_TO_FLAG VARCHAR2 1 Yes This flag indicates whether the resource is directly reporting to the manager Active
START_DATE_ACTIVE DATE Yes Active Start date of the Relation Active
END_DATE_ACTIVE DATE Active End date od Relation Active
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. Active
PAR_ROLE_RELATE_ID NUMBER The role relation Identifier of the manager record Active
CHILD_ROLE_RELATE_ID NUMBER The Role Relate Identifier of the member Active
PARENT_RESOURCE_ID NUMBER The resource id of the manager Active
DENORM_LEVEL NUMBER Column to show the depth of the hierarchy Active
CONFLICT_ID NUMBER 18 Yes Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). Active
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). Active
CPDRF_VER_SOR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows.
CPDRF_VER_PILLAR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows
CPDRF_LAST_UPD VARCHAR2 15 Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows.

Foreign Keys

Table Foreign Table Foreign Key Column
JTF_RS_REP_MANAGERS hz_parties RESOURCE_ID
JTF_RS_REP_MANAGERS hz_parties PARENT_RESOURCE_ID

Indexes

Index Uniqueness Tablespace Columns
JTF_RS_REP_MANAGERS_N1 Non Unique Default GROUP_ID
JTF_RS_REP_MANAGERS_N2 Non Unique Default CHILD_ROLE_RELATE_ID, GROUP_ID, PAR_ROLE_RELATE_ID
JTF_RS_REP_MANAGERS_N3 Non Unique Default TREE_VERSION_ID, RESOURCE_ID, PARENT_RESOURCE_ID
JTF_RS_REP_MANAGERS_N4 Non Unique Default PARENT_RESOURCE_ID, RESOURCE_ID
JTF_RS_REP_MANAGERS_N5 Non Unique Default CREATION_DATE
JTF_RS_REP_MANAGERS_N6 Non Unique Default RESOURCE_ID, END_DATE_ACTIVE, REPORTS_TO_FLAG
JTF_RS_REP_MANAGERS_PK Unique Default DENORM_MGR_ID