FND Design Data [Home] [Help]

View: MTL_MVT_STATS_RULE_SETS_VL

Product: INV - Inventory
Description: Multilingual view for Rule Sets tables.
Implementation/DBA Data: ViewAPPS.MTL_MVT_STATS_RULE_SETS_VL
View Text

SELECT B.ROWID ROW_ID
, B.RULE_SET_CODE RULE_SET_CODE
, TL.RULE_SET_DISPLAY_NAME RULE_SET_DISPLAY_NAME
, TL.RULE_SET_DESCRIPTION RULE_SET_DESCRIPTION
, B.RULE_SET_TYPE RULE_SET_TYPE
, B.CATEGORY_SET_ID CATEGORY_SET_ID
, B.SEEDED_FLAG SEEDED_FLAG
, B.CREATED_BY CREATED_BY
, B.CREATION_DATE CREATION_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM MTL_MVT_STATS_RULE_SETS_B B
, MTL_MVT_STATS_RULE_SETS_TL TL
WHERE B.RULE_SET_CODE = TL.RULE_SET_CODE
AND TL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
RULE_SET_CODE
RULE_SET_DISPLAY_NAME
RULE_SET_DESCRIPTION
RULE_SET_TYPE
CATEGORY_SET_ID
SEEDED_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN