eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.WMS_RULES_V

Object Details

Object Name:	WMS_RULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_RULES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row identifier
RULE_ID	NUMBER		Rule identifier
ORGANIZATION_ID	NUMBER		Organization identifier
TYPE_CODE	NUMBER		Rule type code
TYPE_MEANING	VARCHAR2	(80)	Rule type meaning
TYPE_DESCRIPTION	VARCHAR2	(240)	Rule type description
NAME	VARCHAR2	(80)	Rule name
DESCRIPTION	VARCHAR2	(240)	Rule description
QTY_FUNCTION_PARAMETER_ID	NUMBER		Quantity function parameter identifier
QTY_F_PARAMETER_NAME	VARCHAR2	(4000)	Quantity function parameter name
QTY_F_PARAMETER_DESCRIPTION	VARCHAR2	(320)	Quantity function parameter description
QTY_F_OBJECT_ID	NUMBER		Quantity function object identifier
QTY_F_OBJECT_NAME	VARCHAR2	(80)	Quantity function object name
QTY_F_OBJECT_DESCRIPTION	VARCHAR2	(240)	Quantity function object description
ENABLED_FLAG	VARCHAR2	(1)	Flag indicating whether or not the rule is enabled to be assigned to strategies ('Y'/'N')
USER_DEFINED_FLAG	VARCHAR2	(1)	Flag indicating whether or not the rule is user-defined ('Y'/'N')
CREATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
TYPE_HDR_ID	NUMBER
TYPE_HDR_NAME	VARCHAR2	(255)	Type Header Name
TYPE_HDR_DESCRIPTION	VARCHAR2	(4000)	Type Header Description
RULE_WEIGHT	NUMBER
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield segment column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive Flexfield structure defining column
MIN_PICK_TASKS_FLAG	VARCHAR2	(1)
COMMON_TO_ALL_ORGS_FLAG	VARCHAR2	(1)
ALLOCATION_MODE_ID	NUMBER
ALLOCATION_MODE	VARCHAR2	(80)
ACTIVITY_TYPE_ID	NUMBER		Operation plan activity identifier
ACTIVITY_TYPE_NAME	VARCHAR2	(80)	Operation plan activity type name
PLAN_TYPE_ID	NUMBER		Operation plan type identifier
PLAN_TYPE_NAME	VARCHAR2	(80)	Operation plan type name

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      RULE_ID
,      ORGANIZATION_ID
,      TYPE_CODE
,      TYPE_MEANING
,      TYPE_DESCRIPTION
,      NAME
,      DESCRIPTION
,      QTY_FUNCTION_PARAMETER_ID
,      QTY_F_PARAMETER_NAME
,      QTY_F_PARAMETER_DESCRIPTION
,      QTY_F_OBJECT_ID
,      QTY_F_OBJECT_NAME
,      QTY_F_OBJECT_DESCRIPTION
,      ENABLED_FLAG
,      USER_DEFINED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TYPE_HDR_ID
,      TYPE_HDR_NAME
,      TYPE_HDR_DESCRIPTION
,      RULE_WEIGHT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      MIN_PICK_TASKS_FLAG
,      COMMON_TO_ALL_ORGS_FLAG
,      ALLOCATION_MODE_ID
,      ALLOCATION_MODE
,      ACTIVITY_TYPE_ID
,      ACTIVITY_TYPE_NAME
,      PLAN_TYPE_ID
,      PLAN_TYPE_NAME
FROM APPS.WMS_RULES_V;

Dependencies

[top of page]

APPS.WMS_RULES_V references the following:

APPS: BOM_STANDARD_OPERATIONS; CST_COST_GROUPS; MFG_LOOKUPS; WMS_LABEL_FORMATS; WMS_OBJECTS_VL; WMS_OP_PLANS_VL; WMS_PARAMETERS_VL; WMS_PARAMETER_PVT - show dependent code; WMS_RULES_VL

APPS.WMS_RULES_V is referenced by following:

APPS: WMS_ACCESS_RULES_LOV_V