MSC_MRGD_PL_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
MRGD_PRICE_LIST_ID INSTANCE_ID MRGD_PRICE_LIST_NAME DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT MSC_MRGD_PL_B.MRGD_PRICE_LIST_ID, MSC_MRGD_PL_B.INSTANCE_ID, MSC_MRGD_PL_TL.MRGD_PRICE_LIST_NAME, MSC_MRGD_PL_TL.DESCRIPTION, MSC_MRGD_PL_B.CREATED_BY, MSC_MRGD_PL_B.CREATION_DATE, MSC_MRGD_PL_B.LAST_UPDATED_BY, MSC_MRGD_PL_B.LAST_UPDATE_DATE, MSC_MRGD_PL_B.LAST_UPDATE_LOGIN, MSC_MRGD_PL_B.OBJECT_VERSION_NUMBER FROM MSC_MRGD_PL_TL, MSC_MRGD_PL_B WHERE MSC_MRGD_PL_B.MRGD_PRICE_LIST_ID=MSC_MRGD_PL_TL.MRGD_PRICE_LIST_ID AND MSC_MRGD_PL_TL.LANGUAGE = USERENV('LANG')