QSC_PROD_GRP_ATTR

Details

Schema: FUSION
Object owner: QSC
Object type: VIEW

Columns

Name
PROD_GRP_ATTR_ID OBJECT_VERSION_NUMBER REF_NUMBER OBJECT_ID REVISION_NUM CHANGE_NUM PROD_GROUP_ID ATTRIBUTE_OPTION_ID DISPLAY_ORDER_NUM NARROW_BY_FLAG DISPLAY_PROD_LAYOUT_FLAG ADVANCE_SEARCH_FLAG SHOW_ALL_FLAG SORT_BY_FLAG DOMAIN_AUTO_GEN_FLAG UI_MODE_TYPE_CODE ATTR_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USER_LAST_UPDATE_DATE ATTR_NAME

Name

PROD_GRP_ATTR_ID

OBJECT_VERSION_NUMBER

REF_NUMBER

OBJECT_ID

REVISION_NUM

CHANGE_NUM

PROD_GROUP_ID

ATTRIBUTE_OPTION_ID

DISPLAY_ORDER_NUM

NARROW_BY_FLAG

DISPLAY_PROD_LAYOUT_FLAG

ADVANCE_SEARCH_FLAG

SHOW_ALL_FLAG

SORT_BY_FLAG

DOMAIN_AUTO_GEN_FLAG

UI_MODE_TYPE_CODE

ATTR_TYPE_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

USER_LAST_UPDATE_DATE

ATTR_NAME

Query

SQL_Statement
SELECT QSC_PROD_GRP_ATTR_B.PROD_GRP_ATTR_ID PROD_GRP_ATTR_ID, QSC_PROD_GRP_ATTR_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QSC_PROD_GRP_ATTR_B.REF_NUMBER REF_NUMBER, QSC_PROD_GRP_ATTR_B.OBJECT_ID OBJECT_ID, QSC_PROD_GRP_ATTR_B.REVISION_NUM REVISION_NUM, QSC_PROD_GRP_ATTR_B.CHANGE_NUM CHANGE_NUM, QSC_PROD_GRP_ATTR_B.PROD_GROUP_ID PROD_GROUP_ID, QSC_PROD_GRP_ATTR_B.ATTRIBUTE_OPTION_ID ATTRIBUTE_OPTION_ID, QSC_PROD_GRP_ATTR_B.DISPLAY_ORDER_NUM DISPLAY_ORDER_NUM, QSC_PROD_GRP_ATTR_B.NARROW_BY_FLAG NARROW_BY_FLAG, QSC_PROD_GRP_ATTR_B.DISPLAY_PROD_LAYOUT_FLAG DISPLAY_PROD_LAYOUT_FLAG, QSC_PROD_GRP_ATTR_B.ADVANCE_SEARCH_FLAG ADVANCE_SEARCH_FLAG, QSC_PROD_GRP_ATTR_B.SHOW_ALL_FLAG SHOW_ALL_FLAG, QSC_PROD_GRP_ATTR_B.SORT_BY_FLAG SORT_BY_FLAG, QSC_PROD_GRP_ATTR_B.DOMAIN_AUTO_GEN_FLAG DOMAIN_AUTO_GEN_FLAG, QSC_PROD_GRP_ATTR_B.UI_MODE_TYPE_CODE UI_MODE_TYPE_CODE, QSC_PROD_GRP_ATTR_B.ATTR_TYPE_CODE ATTR_TYPE_CODE, QSC_PROD_GRP_ATTR_B.CREATED_BY CREATED_BY, QSC_PROD_GRP_ATTR_B.CREATION_DATE CREATION_DATE, QSC_PROD_GRP_ATTR_B.LAST_UPDATED_BY LAST_UPDATED_BY, QSC_PROD_GRP_ATTR_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QSC_PROD_GRP_ATTR_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QSC_PROD_GRP_ATTR_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, QSC_PROD_GRP_ATTR_TL.ATTR_NAME ATTR_NAME FROM QSC_PROD_GRP_ATTR_B, QSC_PROD_GRP_ATTR_TL WHERE QSC_PROD_GRP_ATTR_B.PROD_GRP_ATTR_ID = QSC_PROD_GRP_ATTR_TL.PROD_GRP_ATTR_ID AND QSC_PROD_GRP_ATTR_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

QSC_PROD_GRP_ATTR_B.PROD_GRP_ATTR_ID PROD_GRP_ATTR_ID,

QSC_PROD_GRP_ATTR_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

QSC_PROD_GRP_ATTR_B.REF_NUMBER REF_NUMBER,

QSC_PROD_GRP_ATTR_B.OBJECT_ID OBJECT_ID,

QSC_PROD_GRP_ATTR_B.REVISION_NUM REVISION_NUM,

QSC_PROD_GRP_ATTR_B.CHANGE_NUM CHANGE_NUM,

QSC_PROD_GRP_ATTR_B.PROD_GROUP_ID PROD_GROUP_ID,

QSC_PROD_GRP_ATTR_B.ATTRIBUTE_OPTION_ID ATTRIBUTE_OPTION_ID,

QSC_PROD_GRP_ATTR_B.DISPLAY_ORDER_NUM DISPLAY_ORDER_NUM,

QSC_PROD_GRP_ATTR_B.NARROW_BY_FLAG NARROW_BY_FLAG,

QSC_PROD_GRP_ATTR_B.DISPLAY_PROD_LAYOUT_FLAG DISPLAY_PROD_LAYOUT_FLAG,

QSC_PROD_GRP_ATTR_B.ADVANCE_SEARCH_FLAG ADVANCE_SEARCH_FLAG,

QSC_PROD_GRP_ATTR_B.SHOW_ALL_FLAG SHOW_ALL_FLAG,

QSC_PROD_GRP_ATTR_B.SORT_BY_FLAG SORT_BY_FLAG,

QSC_PROD_GRP_ATTR_B.DOMAIN_AUTO_GEN_FLAG DOMAIN_AUTO_GEN_FLAG,

QSC_PROD_GRP_ATTR_B.UI_MODE_TYPE_CODE UI_MODE_TYPE_CODE,

QSC_PROD_GRP_ATTR_B.ATTR_TYPE_CODE ATTR_TYPE_CODE,

QSC_PROD_GRP_ATTR_B.CREATED_BY CREATED_BY,

QSC_PROD_GRP_ATTR_B.CREATION_DATE CREATION_DATE,

QSC_PROD_GRP_ATTR_B.LAST_UPDATED_BY LAST_UPDATED_BY,

QSC_PROD_GRP_ATTR_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QSC_PROD_GRP_ATTR_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QSC_PROD_GRP_ATTR_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE,

QSC_PROD_GRP_ATTR_TL.ATTR_NAME ATTR_NAME

FROM

QSC_PROD_GRP_ATTR_B,

QSC_PROD_GRP_ATTR_TL

WHERE

QSC_PROD_GRP_ATTR_B.PROD_GRP_ATTR_ID = QSC_PROD_GRP_ATTR_TL.PROD_GRP_ATTR_ID AND QSC_PROD_GRP_ATTR_TL.LANGUAGE = USERENV('LANG')