1. Tables and Views for Sales, Fusion Service, and Field Service
  2. QSC_PROD_GRP_ATVAL_B

QSC_PROD_GRP_ATVAL_B

This table stores the domain for the attributes specified in the QSC_PROD_GRP_ATTR_B table.

Details

  • Schema: FUSION

  • Object owner: QSC

  • Object type: TABLE

  • Tablespace: FUSION_TS_SEED

Primary Key

Name Columns

QSC_PROD_GRP_ATVAL_B_PK

PROD_GRP_ATVAL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PROD_GRP_ATVAL_ID NUMBER 18 Yes Product Group Attribute Value 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. Active
REF_NUMBER VARCHAR2 50 Yes Identifier used for integration with external systems. Active
REVISION_NUM NUMBER 18 Yes Revision Number Active
OBJECT_ID NUMBER 18 Yes Persistent Id used to reference the original version. Active
ATTR_OBJECT_ID NUMBER 18 Yes Parent Attribute Reference Identifier. Persistent Id used to reference the original attribute version. Active
CHANGE_NUM NUMBER 18 Column for internal use. Used internally for publishing product groups. Active
PROD_GROUP_ID NUMBER 18 Yes Product Group Identifier. Active
ATTR_VALUE VARCHAR2 150 Value of the attribute. Active
VALUE_ID NUMBER 18 Foreign Key to FND_VS_VALUES_B.
MIN_VALUE_NUM NUMBER 22 Numeric value. Minimum value in a range.
DISPLAY_ORDER_NUM NUMBER 18 Manually set display order for attribute domain.
MAX_VALUE_NUM NUMBER 22 Numeric value. Maximum value in a range. Active
CURRENCY_CODE VARCHAR2 15 Currency Code. Active
UOM_CODE VARCHAR2 3 Refers to the unit of measure code for numeric attributes.
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

Foreign Keys

Table Foreign Table Foreign Key Column
QSC_PROD_GRP_ATVAL_B qsc_prod_groups_b PROD_GROUP_ID
qsc_prod_grp_atval_tl qsc_prod_grp_atval_b PROD_GRP_ATVAL_ID

Indexes

Index Uniqueness Tablespace Columns
QSC_PROD_GRP_ATVAL_B_F2 Non Unique FUSION_TS_SEED CURRENCY_CODE
QSC_PROD_GRP_ATVAL_B_F3 Non Unique Default VALUE_ID
QSC_PROD_GRP_ATVAL_B_N1 Non Unique FUSION_TS_SEED ATTR_OBJECT_ID
QSC_PROD_GRP_ATVAL_B_N2 Non Unique FUSION_TS_SEED LAST_UPDATE_DATE, PROD_GRP_ATVAL_ID
QSC_PROD_GRP_ATVAL_B_PK Unique FUSION_TS_SEED PROD_GRP_ATVAL_ID
QSC_PROD_GRP_ATVAL_B_U1 Unique FUSION_TS_SEED PROD_GROUP_ID, REVISION_NUM, OBJECT_ID