QSC_PROD_GROUPS

Details

Schema: FUSION
Object owner: QSC
Object type: VIEW

Columns

Name
PROD_GROUP_ID OBJECT_VERSION_NUMBER INTERNAL_NAME ADMIN_REVISION_NUM RUNTIME_REVISION_NUM REF_NUMBER LOCKED_BY_USER_GUID LOCKED_DATE LOCKED_FLAG IMAGE_IDENTIFIER_PATH ADMIN_STATE_PENDING_NUM LAST_STRUCT_CHANGE_DATE BATCH_KEY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN USER_LAST_UPDATE_DATE LAST_PUBLISH_DATE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE LANGUAGE PROD_GROUP_NAME PROD_GROUP_DESC_TEXT ADMIN_PROD_GRP_NAME ADMIN_PROD_GRP_DESC_TEXT TL_LAST_UPDATE_DATE AGGREG_LAST_UPDATE_DATE

Name

PROD_GROUP_ID

OBJECT_VERSION_NUMBER

INTERNAL_NAME

ADMIN_REVISION_NUM

RUNTIME_REVISION_NUM

REF_NUMBER

LOCKED_BY_USER_GUID

LOCKED_DATE

LOCKED_FLAG

IMAGE_IDENTIFIER_PATH

ADMIN_STATE_PENDING_NUM

LAST_STRUCT_CHANGE_DATE

BATCH_KEY

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

USER_LAST_UPDATE_DATE

LAST_PUBLISH_DATE

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

LANGUAGE

PROD_GROUP_NAME

PROD_GROUP_DESC_TEXT

ADMIN_PROD_GRP_NAME

ADMIN_PROD_GRP_DESC_TEXT

TL_LAST_UPDATE_DATE

AGGREG_LAST_UPDATE_DATE

Query

SQL_Statement
SELECT QSC_PROD_GROUPS_B.PROD_GROUP_ID PROD_GROUP_ID, QSC_PROD_GROUPS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QSC_PROD_GROUPS_B.INTERNAL_NAME INTERNAL_NAME, QSC_PROD_GROUPS_B.ADMIN_REVISION_NUM ADMIN_REVISION_NUM, QSC_PROD_GROUPS_B.RUNTIME_REVISION_NUM RUNTIME_REVISION_NUM, QSC_PROD_GROUPS_B.REF_NUMBER REF_NUMBER, QSC_PROD_GROUPS_B.LOCKED_BY_USER_GUID LOCKED_BY_USER_GUID, QSC_PROD_GROUPS_B.LOCKED_DATE LOCKED_DATE, QSC_PROD_GROUPS_B.LOCKED_FLAG LOCKED_FLAG, QSC_PROD_GROUPS_B.IMAGE_IDENTIFIER_PATH IMAGE_IDENTIFIER_PATH, QSC_PROD_GROUPS_B.ADMIN_STATE_PENDING_NUM ADMIN_STATE_PENDING_NUM, QSC_PROD_GROUPS_B.LAST_STRUCT_CHANGE_DATE LAST_STRUCT_CHANGE_DATE, QSC_PROD_GROUPS_B.BATCH_KEY BATCH_KEY, QSC_PROD_GROUPS_B.CREATED_BY CREATED_BY, QSC_PROD_GROUPS_B.CREATION_DATE CREATION_DATE, QSC_PROD_GROUPS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QSC_PROD_GROUPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QSC_PROD_GROUPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QSC_PROD_GROUPS_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, QSC_PROD_GROUPS_B.LAST_PUBLISH_DATE LAST_PUBLISH_DATE, QSC_PROD_GROUPS_B.REQUEST_ID REQUEST_ID, QSC_PROD_GROUPS_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, QSC_PROD_GROUPS_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, QSC_PROD_GROUPS_TL.LANGUAGE LANGUAGE, QSC_PROD_GROUPS_TL.PROD_GROUP_NAME PROD_GROUP_NAME, QSC_PROD_GROUPS_TL.PROD_GROUP_DESC_TEXT PROD_GROUP_DESC_TEXT, QSC_PROD_GROUPS_TL.ADMIN_PROD_GRP_NAME ADMIN_PROD_GRP_NAME, QSC_PROD_GROUPS_TL.ADMIN_PROD_GRP_DESC_TEXT ADMIN_PROD_GRP_DESC_TEXT, QSC_PROD_GROUPS_TL.LAST_UPDATE_DATE TL_LAST_UPDATE_DATE, GREATEST (QSC_PROD_GROUPS_B.LAST_UPDATE_DATE, QSC_PROD_GROUPS_TL.LAST_UPDATE_DATE) AGGREG_LAST_UPDATE_DATE FROM QSC_PROD_GROUPS_B, QSC_PROD_GROUPS_TL WHERE QSC_PROD_GROUPS_B.PROD_GROUP_ID = QSC_PROD_GROUPS_TL.PROD_GROUP_ID AND QSC_PROD_GROUPS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

QSC_PROD_GROUPS_B.PROD_GROUP_ID PROD_GROUP_ID,

QSC_PROD_GROUPS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

QSC_PROD_GROUPS_B.INTERNAL_NAME INTERNAL_NAME,

QSC_PROD_GROUPS_B.ADMIN_REVISION_NUM ADMIN_REVISION_NUM,

QSC_PROD_GROUPS_B.RUNTIME_REVISION_NUM RUNTIME_REVISION_NUM,

QSC_PROD_GROUPS_B.REF_NUMBER REF_NUMBER,

QSC_PROD_GROUPS_B.LOCKED_BY_USER_GUID LOCKED_BY_USER_GUID,

QSC_PROD_GROUPS_B.LOCKED_DATE LOCKED_DATE,

QSC_PROD_GROUPS_B.LOCKED_FLAG LOCKED_FLAG,

QSC_PROD_GROUPS_B.IMAGE_IDENTIFIER_PATH IMAGE_IDENTIFIER_PATH,

QSC_PROD_GROUPS_B.ADMIN_STATE_PENDING_NUM ADMIN_STATE_PENDING_NUM,

QSC_PROD_GROUPS_B.LAST_STRUCT_CHANGE_DATE LAST_STRUCT_CHANGE_DATE,

QSC_PROD_GROUPS_B.BATCH_KEY BATCH_KEY,

QSC_PROD_GROUPS_B.CREATED_BY CREATED_BY,

QSC_PROD_GROUPS_B.CREATION_DATE CREATION_DATE,

QSC_PROD_GROUPS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

QSC_PROD_GROUPS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QSC_PROD_GROUPS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QSC_PROD_GROUPS_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE,

QSC_PROD_GROUPS_B.LAST_PUBLISH_DATE LAST_PUBLISH_DATE,

QSC_PROD_GROUPS_B.REQUEST_ID REQUEST_ID,

QSC_PROD_GROUPS_B.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

QSC_PROD_GROUPS_B.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

QSC_PROD_GROUPS_TL.LANGUAGE LANGUAGE,

QSC_PROD_GROUPS_TL.PROD_GROUP_NAME PROD_GROUP_NAME,

QSC_PROD_GROUPS_TL.PROD_GROUP_DESC_TEXT PROD_GROUP_DESC_TEXT,

QSC_PROD_GROUPS_TL.ADMIN_PROD_GRP_NAME ADMIN_PROD_GRP_NAME,

QSC_PROD_GROUPS_TL.ADMIN_PROD_GRP_DESC_TEXT ADMIN_PROD_GRP_DESC_TEXT,

QSC_PROD_GROUPS_TL.LAST_UPDATE_DATE TL_LAST_UPDATE_DATE,

GREATEST (QSC_PROD_GROUPS_B.LAST_UPDATE_DATE, QSC_PROD_GROUPS_TL.LAST_UPDATE_DATE) AGGREG_LAST_UPDATE_DATE

FROM

QSC_PROD_GROUPS_B,

QSC_PROD_GROUPS_TL

WHERE

QSC_PROD_GROUPS_B.PROD_GROUP_ID = QSC_PROD_GROUPS_TL.PROD_GROUP_ID AND QSC_PROD_GROUPS_TL.LANGUAGE = USERENV('LANG')