INV_RULES_VL

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

RULE_ID LAST_UPDATED_BY LAST_UPDATE_DATE CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN ORGANIZATION_ID TYPE_CODE RULE_NAME DESCRIPTION QTY_FUNCTION_PARAMETER_ID ENABLED_FLAG USER_DEFINED_FLAG TYPE_HDR_ID RULE_WEIGHT ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ROW_ID MIN_PICK_TASKS_FLAG ALLOCATION_MODE_ID WMS_ENABLED_FLAG OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT wrb.RULE_ID ,wrb.LAST_UPDATED_BY ,wrb.LAST_UPDATE_DATE ,wrb.CREATED_BY ,wrb.CREATION_DATE ,wrb.LAST_UPDATE_LOGIN ,wrb.ORGANIZATION_ID ,wrb.TYPE_CODE ,wrtl.RULE_NAME ,wrtl.DESCRIPTION ,wrb.QTY_FUNCTION_PARAMETER_ID ,wrb.ENABLED_FLAG ,wrb.USER_DEFINED_FLAG ,wrb.TYPE_HDR_ID ,wrb.RULE_WEIGHT ,wrb.ATTRIBUTE_CATEGORY ,wrb.ATTRIBUTE1 ,wrb.ATTRIBUTE2 ,wrb.ATTRIBUTE3 ,wrb.ATTRIBUTE4 ,wrb.ATTRIBUTE5 ,wrb.ATTRIBUTE6 ,wrb.ATTRIBUTE7 ,wrb.ATTRIBUTE8 ,wrb.ATTRIBUTE9 ,wrb.ATTRIBUTE10 ,wrb.ATTRIBUTE11 ,wrb.ATTRIBUTE12 ,wrb.ATTRIBUTE13 ,wrb.ATTRIBUTE14 ,wrb.ATTRIBUTE15 ,wrb.rowid row_id ,wrb.MIN_PICK_TASKS_FLAG ,wrb.allocation_mode_id ,wrb.wms_enabled_flag, wrb.OBJECT_VERSION_NUMBER FROM INV_RULES_TL wrtl ,INV_RULES_B wrb WHERE wrtl.RULE_ID = wrb.RULE_ID AND wrtl.LANGUAGE = userenv('LANG')