QSC_PROD_GRP_USAGE
This table is used to define the different application channel usage areas using product groups.
Details
-
Schema: FUSION
-
Object owner: QSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
QSC_PROD_GRP_USAGE_PK |
USAGE_CODE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
USAGE_CODE | VARCHAR2 | 30 | Yes | Unique Usage Code Identifier. | 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 | |
USAGE_NAME | VARCHAR2 | 100 | Yes | Usage Name. | Active | |
USAGE_DESC_TEXT | VARCHAR2 | 250 | Usage Description | Active | ||
ALLOW_DUP_CONTENT_FLAG | VARCHAR2 | 1 | Set this flag to 'N' to indicate that only root product groups whose Allow Duplicate Content Flag is set to 'N' can be assigned for this usage. This flag is used to determine whether duplicate product or product groups are allowed in a product group hierarchy assigned to this usage. | 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 | ||
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 | |||
CUSTOMIZATION_LEVEL | VARCHAR2 | 1 | Yes | Used to enforce rules, restricting how and by whom the particular row can be edited. | ||
SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
qsc_prod_grp_roots | qsc_prod_grp_usage | USAGE_CODE |
qsc_prod_grp_usage_pref | qsc_prod_grp_usage | USAGE_CODE |
qsc_prod_grp_vo_access | qsc_prod_grp_usage | USAGE_CODE |
qsc_prod_grp_usage_mode | qsc_prod_grp_usage | USAGE_CODE |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
QSC_PROD_GRP_USAGE_N1 | Non Unique | FUSION_TS_SEED | LAST_UPDATE_DATE, USAGE_CODE | Active |
QSC_PROD_GRP_USAGE_PK | Unique | FUSION_TS_SEED | USAGE_CODE, ORA_SEED_SET1 | Active |
QSC_PROD_GRP_USAGE_PK1 | Unique | FUSION_TS_SEED | USAGE_CODE, ORA_SEED_SET2 | |
QSC_PROD_GRP_USAGE_U1 | Unique | FUSION_TS_SEED | USAGE_NAME, ORA_SEED_SET1 | Active |
QSC_PROD_GRP_USAGE_U11 | Unique | FUSION_TS_SEED | USAGE_NAME, ORA_SEED_SET2 |