QSC_PROD_GRP_REL_VL

Details

• Schema: FUSION

• Object owner: QSC

• Object type: VIEW

Columns

Name
PROD_GRP_REL_ID OBJECT_VERSION_NUMBER PROD_GROUP_ID REL_PROD_GROUP_ID RELATION_TYPE_CODE REVISION_NUM CHANGE_NUM REF_NUMBER OBJECT_ID START_DATE END_DATE ACTIVE_FLAG UI_COLLAPSE_FLAG DISPLAY_ORDER_NUM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USER_LAST_UPDATE_DATE LANGUAGE PROD_GRP_REL_NAME

Query

SQL_Statement

SELECT QSC_PROD_GRP_REL_B.PROD_GRP_REL_ID PROD_GRP_REL_ID, QSC_PROD_GRP_REL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QSC_PROD_GRP_REL_B.PROD_GROUP_ID PROD_GROUP_ID, QSC_PROD_GRP_REL_B.REL_PROD_GROUP_ID REL_PROD_GROUP_ID, QSC_PROD_GRP_REL_B.RELATION_TYPE_CODE RELATION_TYPE_CODE, QSC_PROD_GRP_REL_B.REVISION_NUM REVISION_NUM, QSC_PROD_GRP_REL_B.CHANGE_NUM CHANGE_NUM, QSC_PROD_GRP_REL_B.REF_NUMBER REF_NUMBER, QSC_PROD_GRP_REL_B.OBJECT_ID OBJECT_ID, QSC_PROD_GRP_REL_B.START_DATE START_DATE, QSC_PROD_GRP_REL_B.END_DATE END_DATE, QSC_PROD_GRP_REL_B.ACTIVE_FLAG ACTIVE_FLAG, QSC_PROD_GRP_REL_B.UI_COLLAPSE_FLAG UI_COLLAPSE_FLAG, QSC_PROD_GRP_REL_B.DISPLAY_ORDER_NUM DISPLAY_ORDER_NUM, QSC_PROD_GRP_REL_B.CREATED_BY CREATED_BY, QSC_PROD_GRP_REL_B.CREATION_DATE CREATION_DATE, QSC_PROD_GRP_REL_B.LAST_UPDATED_BY LAST_UPDATED_BY, QSC_PROD_GRP_REL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QSC_PROD_GRP_REL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QSC_PROD_GRP_REL_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, QSC_PROD_GRP_REL_TL.LANGUAGE LANGUAGE, QSC_PROD_GRP_REL_TL.PROD_GRP_REL_NAME PROD_GRP_REL_NAME FROM QSC_PROD_GRP_REL_B, QSC_PROD_GRP_REL_TL WHERE QSC_PROD_GRP_REL_B.PROD_GRP_REL_ID = QSC_PROD_GRP_REL_TL.PROD_GRP_REL_ID AND QSC_PROD_GRP_REL_TL.LANGUAGE = USERENV('LANG')