QSC_PROD_TMPL_MAPPINGS

Details

Schema: FUSION
Object owner: QSC
Object type: VIEW

Columns

Name
PROD_TMPL_MAPPING_ID PROD_TMPL_MAPPING_CODE INVENTORY_ITEM_ID ORGANIZATION_ID ITEM_CLASS_GROUP_ID CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY OBJECT_VERSION_NUMBER LANGUAGE SOURCE_LANG DESCRIPTION LONG_DESCRIPTION

Name

PROD_TMPL_MAPPING_ID

PROD_TMPL_MAPPING_CODE

INVENTORY_ITEM_ID

ORGANIZATION_ID

ITEM_CLASS_GROUP_ID

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

CREATED_BY

OBJECT_VERSION_NUMBER

LANGUAGE

SOURCE_LANG

DESCRIPTION

LONG_DESCRIPTION

Query

SQL_Statement
SELECT QSC_PROD_TMPL_MAPPINGS_B.PROD_TMPL_MAPPING_ID PROD_TMPL_MAPPING_ID, QSC_PROD_TMPL_MAPPINGS_B.PROD_TMPL_MAPPING_CODE PROD_TMPL_MAPPING_CODE, QSC_PROD_TMPL_MAPPINGS_B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, QSC_PROD_TMPL_MAPPINGS_B.ORGANIZATION_ID ORGANIZATION_ID, QSC_PROD_TMPL_MAPPINGS_B.ITEM_CLASS_GROUP_ID ITEM_CLASS_GROUP_ID, QSC_PROD_TMPL_MAPPINGS_B.CREATION_DATE CREATION_DATE, QSC_PROD_TMPL_MAPPINGS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QSC_PROD_TMPL_MAPPINGS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QSC_PROD_TMPL_MAPPINGS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QSC_PROD_TMPL_MAPPINGS_B.CREATED_BY CREATED_BY, QSC_PROD_TMPL_MAPPINGS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QSC_PROD_TMPL_MAPPINGS_TL.LANGUAGE LANGUAGE, QSC_PROD_TMPL_MAPPINGS_TL.SOURCE_LANG SOURCE_LANG, QSC_PROD_TMPL_MAPPINGS_TL.DESCRIPTION DESCRIPTION, QSC_PROD_TMPL_MAPPINGS_TL.LONG_DESCRIPTION LONG_DESCRIPTION FROM QSC_PROD_TMPL_MAPPINGS_B, QSC_PROD_TMPL_MAPPINGS_TL WHERE QSC_PROD_TMPL_MAPPINGS_B.PROD_TMPL_MAPPING_ID = QSC_PROD_TMPL_MAPPINGS_TL.PROD_TMPL_MAPPING_ID AND QSC_PROD_TMPL_MAPPINGS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

QSC_PROD_TMPL_MAPPINGS_B.PROD_TMPL_MAPPING_ID PROD_TMPL_MAPPING_ID,

QSC_PROD_TMPL_MAPPINGS_B.PROD_TMPL_MAPPING_CODE PROD_TMPL_MAPPING_CODE,

QSC_PROD_TMPL_MAPPINGS_B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

QSC_PROD_TMPL_MAPPINGS_B.ORGANIZATION_ID ORGANIZATION_ID,

QSC_PROD_TMPL_MAPPINGS_B.ITEM_CLASS_GROUP_ID ITEM_CLASS_GROUP_ID,

QSC_PROD_TMPL_MAPPINGS_B.CREATION_DATE CREATION_DATE,

QSC_PROD_TMPL_MAPPINGS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

QSC_PROD_TMPL_MAPPINGS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

QSC_PROD_TMPL_MAPPINGS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

QSC_PROD_TMPL_MAPPINGS_B.CREATED_BY CREATED_BY,

QSC_PROD_TMPL_MAPPINGS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

QSC_PROD_TMPL_MAPPINGS_TL.LANGUAGE LANGUAGE,

QSC_PROD_TMPL_MAPPINGS_TL.SOURCE_LANG SOURCE_LANG,

QSC_PROD_TMPL_MAPPINGS_TL.DESCRIPTION DESCRIPTION,

QSC_PROD_TMPL_MAPPINGS_TL.LONG_DESCRIPTION LONG_DESCRIPTION

FROM

QSC_PROD_TMPL_MAPPINGS_B,

QSC_PROD_TMPL_MAPPINGS_TL

WHERE

QSC_PROD_TMPL_MAPPINGS_B.PROD_TMPL_MAPPING_ID = QSC_PROD_TMPL_MAPPINGS_TL.PROD_TMPL_MAPPING_ID AND QSC_PROD_TMPL_MAPPINGS_TL.LANGUAGE = USERENV('LANG')