ZCA_AG_INTERSECTION_GROUPS_GT

This Global Temp Table for a session. It stores the records to be created for system groups

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Precision Comments
OBJECT_ID NUMBER 18 To store the Primary key of the source of system groups like Resource Id, Territory Id
PARTY_ID NUMBER 18 To store the Primary key of the user who is a member of the corresponding system group
ACCESS_GROUP_ID1 NUMBER 18 To store the Access Group Id of the intersection groups corresponding to this Object Id
ACCESS_GROUP_ID2 NUMBER 18 To store the Access Group Id of the Role/Custom Access Group corresponding to this Intersection Group