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.

[Home] [Help]

View: WMS_RULES_V

Product:	WMS - Warehouse Management
Description:	WMS rule view
Implementation/DBA Data:	APPS.WMS_RULES_V

View Text

SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.QTY_FUNCTION_PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.DESCRIPTION
, WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, NVL(WRVL.ALLOCATION_MODE_ID
, 4) ALLOCATION_MODE_ID
, M2.MEANING ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, MFG_LOOKUPS M2
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE = WRVL.TYPE_CODE
AND WPVL.PARAMETER_ID = WRVL.QTY_FUNCTION_PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND ML.LOOKUP_CODE = 2
AND (M2.LOOKUP_TYPE = 'WMS_RULE_ALLOCATION_MODE'
AND M2.LOOKUP_CODE = NVL(WRVL.ALLOCATION_MODE_ID
, 4))
AND NVL(WRVL.WMS_ENABLED_FLAG
, 'Y') = 'Y' UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.QTY_FUNCTION_PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.DESCRIPTION
, WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE = WRVL.TYPE_CODE
AND WPVL.PARAMETER_ID = WRVL.QTY_FUNCTION_PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND ML.LOOKUP_CODE = 1 UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, TT.OPERATION_CODE
, TT.OPERATION_DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, BOM_STANDARD_OPERATIONS TT
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 3
AND WRVL.ORGANIZATION_ID = TT.ORGANIZATION_ID
AND TT.WMS_TASK_TYPE IS NOT NULL
AND WRVL.TYPE_HDR_ID = TT.STANDARD_OPERATION_ID UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, WLF.LABEL_FORMAT_NAME
, WLF.FORMAT_DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, WMS_LABEL_FORMATS WLF
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 4
AND WRVL.TYPE_HDR_ID = WLF.LABEL_FORMAT_ID UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, CG.COST_GROUP
, CG.DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, CST_COST_GROUPS CG
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 5
AND WRVL.ORGANIZATION_ID = NVL(CG.ORGANIZATION_ID
, WRVL.ORGANIZATION_ID)
AND WRVL.TYPE_HDR_ID = CG.COST_GROUP_ID UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, OP.OPERATION_PLAN_NAME
, OP.DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, OP.ACTIVITY_TYPE_ID ACTIVITY_TYPE_ID
, M3.MEANING ACTIVITY_TYPE_NAME
, OP.PLAN_TYPE_ID PLAN_TYPE_ID
, M4.MEANING PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, WMS_OP_PLANS_VL OP
, MFG_LOOKUPS M3
, MFG_LOOKUPS M4
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 7
AND WRVL.ORGANIZATION_ID = NVL(OP.ORGANIZATION_ID
, WRVL.ORGANIZATION_ID)
AND WRVL.TYPE_HDR_ID = OP.OPERATION_PLAN_ID
AND (M3.LOOKUP_TYPE = 'WMS_ACTIVITY_TYPES'
AND M3.LOOKUP_CODE = OP.ACTIVITY_TYPE_ID)
AND (M4.LOOKUP_TYPE =DECODE(OP.ACTIVITY_TYPE_ID
, 1
, 'WMS_OP_INBOUND_TYPES'
, 2
, 'WMS_OP_OUTBOUND_TYPES')
AND M4.LOOKUP_CODE = OP.PLAN_TYPE_ID)

Columns

Name
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