QSC_PROD_GRP_ATVAL_VL

Details

• Schema: FUSION

• Object owner: QSC

• Object type: VIEW

Columns

Name
PROD_GRP_ATVAL_ID OBJECT_VERSION_NUMBER REF_NUMBER OBJECT_ID PROD_GROUP_ID REVISION_NUM CHANGE_NUM ATTR_OBJECT_ID DISPLAY_ORDER_NUM UOM_CODE VALUE_ID ATTR_VALUE MIN_VALUE_NUM MAX_VALUE_NUM CURRENCY_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USER_LAST_UPDATE_DATE ATTR_VALUE_NAME

Query

SQL_Statement

SELECT QSC_PROD_GRP_ATVAL_B.PROD_GRP_ATVAL_ID PROD_GRP_ATVAL_ID, QSC_PROD_GRP_ATVAL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QSC_PROD_GRP_ATVAL_B.REF_NUMBER REF_NUMBER, QSC_PROD_GRP_ATVAL_B.OBJECT_ID OBJECT_ID, QSC_PROD_GRP_ATVAL_B.PROD_GROUP_ID PROD_GROUP_ID, QSC_PROD_GRP_ATVAL_B.REVISION_NUM REVISION_NUM, QSC_PROD_GRP_ATVAL_B.CHANGE_NUM CHANGE_NUM, QSC_PROD_GRP_ATVAL_B.ATTR_OBJECT_ID ATTR_OBJECT_ID, QSC_PROD_GRP_ATVAL_B.DISPLAY_ORDER_NUM DISPLAY_ORDER_NUM, QSC_PROD_GRP_ATVAL_B.UOM_CODE UOM_CODE, QSC_PROD_GRP_ATVAL_B.VALUE_ID VALUE_ID, QSC_PROD_GRP_ATVAL_B.ATTR_VALUE ATTR_VALUE, QSC_PROD_GRP_ATVAL_B.MIN_VALUE_NUM MIN_VALUE_NUM, QSC_PROD_GRP_ATVAL_B.MAX_VALUE_NUM MAX_VALUE_NUM, QSC_PROD_GRP_ATVAL_B.CURRENCY_CODE CURRENCY_CODE, QSC_PROD_GRP_ATVAL_B.CREATED_BY CREATED_BY, QSC_PROD_GRP_ATVAL_B.CREATION_DATE CREATION_DATE, QSC_PROD_GRP_ATVAL_B.LAST_UPDATED_BY LAST_UPDATED_BY, QSC_PROD_GRP_ATVAL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QSC_PROD_GRP_ATVAL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QSC_PROD_GRP_ATVAL_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, QSC_PROD_GRP_ATVAL_TL.ATTR_VALUE_NAME ATTR_VALUE_NAME FROM QSC_PROD_GRP_ATVAL_B, QSC_PROD_GRP_ATVAL_TL WHERE QSC_PROD_GRP_ATVAL_B.PROD_GRP_ATVAL_ID = QSC_PROD_GRP_ATVAL_TL.PROD_GRP_ATVAL_ID AND QSC_PROD_GRP_ATVAL_TL.LANGUAGE = USERENV('LANG')