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_SELECTION_CRITERIA_TXN_V

Product:	WMS - Warehouse Management
Description:	This view shows information about the selection criteria for WMS Rules
Implementation/DBA Data:	APPS.WMS_SELECTION_CRITERIA_TXN_V

View Text

SELECT WSCT.STG_ASSIGNMENT_ID
, WSCT.SEQUENCE_NUMBER
, WSCT.RULE_TYPE_CODE
, DECODE(WSCT.RULE_TYPE_CODE
, 2
, 'PICK'
, 1
, 'PUTAWAY'
, 3
, 'TASK'
, 4
, 'LABEL'
, 5
, 'COST_CROUP'
, 10
, 'SUPPLY_CROSSDOCK'
, 11
, 'DEMAND_CROSSDOCK'
, 12
, 'CARTONIZATION') RULE_TYPE
, WSCT.RETURN_TYPE_CODE RETURN_TYPE
, WSCT.RETURN_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_RETURN_TYPE_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.RULE_TYPE_CODE
, WSCT.RETURN_TYPE_CODE
, WSCT.RETURN_TYPE_ID) RETURN_TYPE_NAME
, WSCT.ENABLED_FLAG
, WSCT.DATE_TYPE_CODE
, WSCT.DATE_TYPE_FROM
, WSCT.DATE_TYPE_TO
, WSCT.DATE_TYPE_LOOKUP_TYPE
, WSCT.EFFECTIVE_FROM
, WSCT.EFFECTIVE_TO
, WSCT.FROM_ORGANIZATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORGANIZATION_CODE(WSCT.FROM_ORGANIZATION_ID) FROM_ORGANIZATION_CODE
, WSCT.FROM_SUBINVENTORY_NAME
, WSCT.TO_ORGANIZATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORGANIZATION_CODE(WSCT.TO_ORGANIZATION_ID) TO_ORGANIZATION_CODE
, WSCT.TO_SUBINVENTORY_NAME
, WSCT.CUSTOMER_ID
, WMS_RULES_WORKBENCH_PVT.GET_CUSTOMER_NAME(WSCT.CUSTOMER_ID) CUSTOMER_NAME
, WSCT.FREIGHT_CODE
, WMS_RULES_WORKBENCH_PVT.GET_FREIGHT_CODE_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.FREIGHT_CODE) FREIGHT_CODE_NAME
, WSCT.INVENTORY_ITEM_ID
, WMS_RULES_WORKBENCH_PVT.GET_ITEM(WSCT.FROM_ORGANIZATION_ID
, WSCT.INVENTORY_ITEM_ID) ITEM
, WSCT.ITEM_TYPE
, WMS_RULES_WORKBENCH_PVT.GET_ITEM_TYPE_NAME(WSCT.ITEM_TYPE) ITEM_TYPE_NAME
, WSCT.ASSIGNMENT_GROUP_ID
, WSCT.ABC_CLASS_ID
, WMS_RULES_WORKBENCH_PVT.GET_ABC_GROUP_CLASS(WSCT.FROM_ORGANIZATION_ID
, WSCT.ASSIGNMENT_GROUP_ID
, WSCT.ABC_CLASS_ID) ABC_GROUP_CLASS_NAME
, WSCT.CATEGORY_SET_ID
, WSCT.CATEGORY_ID
, WMS_RULES_WORKBENCH_PVT.GET_CATEGORY_SET_NAME( WSCT.FROM_ORGANIZATION_ID
, WSCT.CATEGORY_SET_ID
, WSCT.CATEGORY_ID) CATEGORY_SET_NAME
, WSCT.ORDER_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORDER_TYPE_NAME(WSCT.ORDER_TYPE_ID) ORDER_TYPE_NAME
, WSCT.VENDOR_ID
, WMS_RULES_WORKBENCH_PVT.GET_VENDOR_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.VENDOR_ID) VENDOR_NAME
, WSCT.PROJECT_ID
, WMS_RULES_WORKBENCH_PVT.GET_PROJECT_NAME(WSCT.PROJECT_ID) PROJECT_NAME
, WSCT.TASK_ID
, WMS_RULES_WORKBENCH_PVT.GET_TASK_NAME(WSCT.PROJECT_ID
, WSCT.TASK_ID) TASK_NAME
, WSCT.USER_ID
, WMS_RULES_WORKBENCH_PVT.GET_USER_NAME(WSCT.USER_ID) USER_NAME
, WSCT.TRANSACTION_ACTION_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_ACTION_NAME( WSCT.TRANSACTION_ACTION_ID) TRANSACTION_ACTION_NAME
, WSCT.REASON_ID
, WMS_RULES_WORKBENCH_PVT.GET_REASON_NAME(WSCT.REASON_ID) REASON_NAME
, WSCT.TRANSACTION_SOURCE_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_SOURCE_NAME( WSCT.TRANSACTION_SOURCE_TYPE_ID) TRANSACTION_SOURCE_TYPE_NAME
, WSCT.TRANSACTION_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_TYPE_NAME(WSCT.TRANSACTION_TYPE_ID) TRANSACTION_TYPE_NAME
, WSCT.UOM_CODE
, WMS_RULES_WORKBENCH_PVT.GET_UNIT_OF_MEASURE(WSCT.UOM_CODE) UNIT_OF_MEASURE
, WSCT.UOM_CLASS
, WMS_RULES_WORKBENCH_PVT.GET_UOM_CLASS_NAME(WSCT.UOM_CLASS) UOM_CLASS_NAME
, WSCT.LAST_UPDATE_DATE
, WSCT.CREATED_BY
, WSCT.CREATION_DATE
, WSCT.LAST_UPDATE_LOGIN
, WSCT.LAST_UPDATED_BY
, NVL(WSB.WMS_ENABLED_FLAG
, 'Y') WMS_ENABLED_FLAG
, WSCT.LOCATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_LOCATION_NAME(WSCT.LOCATION_ID) LOCATION_NAME
FROM WMS_SELECTION_CRITERIA_TXN WSCT
, WMS_STRATEGIES_B WSB
WHERE DECODE(WSCT.RETURN_TYPE_CODE
, 'S'
, WSCT.RETURN_TYPE_ID
, NULL) = WSB.STRATEGY_ID UNION ALL SELECT WSCT.STG_ASSIGNMENT_ID
, WSCT.SEQUENCE_NUMBER
, WSCT.RULE_TYPE_CODE
, DECODE(WSCT.RULE_TYPE_CODE
, 2
, 'PICK'
, 1
, 'PUTAWAY'
, 3
, 'TASK'
, 4
, 'LABEL'
, 5
, 'COST_CROUP'
, 10
, 'SUPPLY_CROSSDOCK'
, 11
, 'DEMAND_CROSSDOCK'
, 12
, 'CARTONIZATION') RULE_TYPE
, WSCT.RETURN_TYPE_CODE RETURN_TYPE
, WSCT.RETURN_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_RETURN_TYPE_NAME( WSCT.FROM_ORGANIZATION_ID
, WSCT.RULE_TYPE_CODE
, WSCT.RETURN_TYPE_CODE
, WSCT.RETURN_TYPE_ID) RETURN_TYPE_NAME
, WSCT.ENABLED_FLAG
, WSCT.DATE_TYPE_CODE
, WSCT.DATE_TYPE_FROM
, WSCT.DATE_TYPE_TO
, WSCT.DATE_TYPE_LOOKUP_TYPE
, WSCT.EFFECTIVE_FROM
, WSCT.EFFECTIVE_TO
, WSCT.FROM_ORGANIZATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORGANIZATION_CODE(WSCT.FROM_ORGANIZATION_ID) FROM_ORGANIZATION_CODE
, WSCT.FROM_SUBINVENTORY_NAME
, WSCT.TO_ORGANIZATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORGANIZATION_CODE(WSCT.TO_ORGANIZATION_ID) TO_ORGANIZATION_CODE
, WSCT.TO_SUBINVENTORY_NAME
, WSCT.CUSTOMER_ID
, WMS_RULES_WORKBENCH_PVT.GET_CUSTOMER_NAME(WSCT.CUSTOMER_ID) CUSTOMER_NAME
, WSCT.FREIGHT_CODE
, WMS_RULES_WORKBENCH_PVT.GET_FREIGHT_CODE_NAME( WSCT.FROM_ORGANIZATION_ID
, WSCT.FREIGHT_CODE) FREIGHT_CODE_NAME
, WSCT.INVENTORY_ITEM_ID
, WMS_RULES_WORKBENCH_PVT.GET_ITEM(WSCT.FROM_ORGANIZATION_ID
, WSCT.INVENTORY_ITEM_ID) ITEM
, WSCT.ITEM_TYPE
, WMS_RULES_WORKBENCH_PVT.GET_ITEM_TYPE_NAME(WSCT.ITEM_TYPE) ITEM_TYPE_NAME
, WSCT.ASSIGNMENT_GROUP_ID
, WSCT.ABC_CLASS_ID
, WMS_RULES_WORKBENCH_PVT.GET_ABC_GROUP_CLASS(WSCT.FROM_ORGANIZATION_ID
, WSCT.ASSIGNMENT_GROUP_ID
, WSCT.ABC_CLASS_ID) ABC_GROUP_CLASS_NAME
, WSCT.CATEGORY_SET_ID
, WSCT.CATEGORY_ID
, WMS_RULES_WORKBENCH_PVT.GET_CATEGORY_SET_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.CATEGORY_SET_ID
, WSCT.CATEGORY_ID) CATEGORY_SET_NAME
, WSCT.ORDER_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORDER_TYPE_NAME(WSCT.ORDER_TYPE_ID) ORDER_TYPE_NAME
, WSCT.VENDOR_ID
, WMS_RULES_WORKBENCH_PVT.GET_VENDOR_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.VENDOR_ID) VENDOR_NAME
, WSCT.PROJECT_ID
, WMS_RULES_WORKBENCH_PVT.GET_PROJECT_NAME(WSCT.PROJECT_ID) PROJECT_NAME
, WSCT.TASK_ID
, WMS_RULES_WORKBENCH_PVT.GET_TASK_NAME(WSCT.PROJECT_ID
, WSCT.TASK_ID) TASK_NAME
, WSCT.USER_ID
, WMS_RULES_WORKBENCH_PVT.GET_USER_NAME(WSCT.USER_ID) USER_NAME
, WSCT.TRANSACTION_ACTION_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_ACTION_NAME(WSCT.TRANSACTION_ACTION_ID) TRANSACTION_ACTION_NAME
, WSCT.REASON_ID
, WMS_RULES_WORKBENCH_PVT.GET_REASON_NAME(WSCT.REASON_ID) REASON_NAME
, WSCT.TRANSACTION_SOURCE_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_SOURCE_NAME(WSCT.TRANSACTION_SOURCE_TYPE_ID) TRANSACTION_SOURCE_TYPE_NAME
, WSCT.TRANSACTION_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_TYPE_NAME(WSCT.TRANSACTION_TYPE_ID) TRANSACTION_TYPE_NAME
, WSCT.UOM_CODE
, WMS_RULES_WORKBENCH_PVT.GET_UNIT_OF_MEASURE(WSCT.UOM_CODE) UNIT_OF_MEASURE
, WSCT.UOM_CLASS
, WMS_RULES_WORKBENCH_PVT.GET_UOM_CLASS_NAME(WSCT.UOM_CLASS) UOM_CLASS_NAME
, WSCT.LAST_UPDATE_DATE
, WSCT.CREATED_BY
, WSCT.CREATION_DATE
, WSCT.LAST_UPDATE_LOGIN
, WSCT.LAST_UPDATED_BY
, NVL(WRB.WMS_ENABLED_FLAG
, 'Y') WMS_ENABLED_FLAG
, WSCT.LOCATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_LOCATION_NAME(WSCT.LOCATION_ID) LOCATION_NAME
FROM WMS_SELECTION_CRITERIA_TXN WSCT
, WMS_RULES_B WRB
WHERE DECODE(WSCT.RETURN_TYPE_CODE
, 'R'
, WSCT.RETURN_TYPE_ID
, NULL) = WRB.RULE_ID UNION ALL SELECT WSCT.STG_ASSIGNMENT_ID
, WSCT.SEQUENCE_NUMBER
, WSCT.RULE_TYPE_CODE
, DECODE(WSCT.RULE_TYPE_CODE
, 2
, 'PICK'
, 1
, 'PUTAWAY'
, 3
, 'TASK'
, 4
, 'LABEL'
, 5
, 'COST_CROUP'
, 10
, 'SUPPLY_CROSSDOCK'
, 11
, 'DEMAND_CROSSDOCK'
, 12
, 'CARTONIZATION') RULE_TYPE
, WSCT.RETURN_TYPE_CODE RETURN_TYPE
, WSCT.RETURN_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_RETURN_TYPE_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.RULE_TYPE_CODE
, WSCT.RETURN_TYPE_CODE
, WSCT.RETURN_TYPE_ID) RETURN_TYPE_NAME
, WSCT.ENABLED_FLAG
, WSCT.DATE_TYPE_CODE
, WSCT.DATE_TYPE_FROM
, WSCT.DATE_TYPE_TO
, WSCT.DATE_TYPE_LOOKUP_TYPE
, WSCT.EFFECTIVE_FROM
, WSCT.EFFECTIVE_TO
, WSCT.FROM_ORGANIZATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORGANIZATION_CODE(WSCT.FROM_ORGANIZATION_ID) FROM_ORGANIZATION_CODE
, WSCT.FROM_SUBINVENTORY_NAME
, WSCT.TO_ORGANIZATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORGANIZATION_CODE(WSCT.TO_ORGANIZATION_ID) TO_ORGANIZATION_CODE
, WSCT.TO_SUBINVENTORY_NAME
, WSCT.CUSTOMER_ID
, WMS_RULES_WORKBENCH_PVT.GET_CUSTOMER_NAME(WSCT.CUSTOMER_ID) CUSTOMER_NAME
, WSCT.FREIGHT_CODE
, WMS_RULES_WORKBENCH_PVT.GET_FREIGHT_CODE_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.FREIGHT_CODE) FREIGHT_CODE_NAME
, WSCT.INVENTORY_ITEM_ID
, WMS_RULES_WORKBENCH_PVT.GET_ITEM(WSCT.FROM_ORGANIZATION_ID
, WSCT.INVENTORY_ITEM_ID) ITEM
, WSCT.ITEM_TYPE
, WMS_RULES_WORKBENCH_PVT.GET_ITEM_TYPE_NAME(WSCT.ITEM_TYPE) ITEM_TYPE_NAME
, WSCT.ASSIGNMENT_GROUP_ID
, WSCT.ABC_CLASS_ID
, WMS_RULES_WORKBENCH_PVT.GET_ABC_GROUP_CLASS( WSCT.FROM_ORGANIZATION_ID
, WSCT.ASSIGNMENT_GROUP_ID
, WSCT.ABC_CLASS_ID) ABC_GROUP_CLASS_NAME
, WSCT.CATEGORY_SET_ID
, WSCT.CATEGORY_ID
, WMS_RULES_WORKBENCH_PVT.GET_CATEGORY_SET_NAME( WSCT.FROM_ORGANIZATION_ID
, WSCT.CATEGORY_SET_ID
, WSCT.CATEGORY_ID) CATEGORY_SET_NAME
, WSCT.ORDER_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_ORDER_TYPE_NAME(WSCT.ORDER_TYPE_ID) ORDER_TYPE_NAME
, WSCT.VENDOR_ID
, WMS_RULES_WORKBENCH_PVT.GET_VENDOR_NAME(WSCT.FROM_ORGANIZATION_ID
, WSCT.VENDOR_ID) VENDOR_NAME
, WSCT.PROJECT_ID
, WMS_RULES_WORKBENCH_PVT.GET_PROJECT_NAME(WSCT.PROJECT_ID) PROJECT_NAME
, WSCT.TASK_ID
, WMS_RULES_WORKBENCH_PVT.GET_TASK_NAME(WSCT.PROJECT_ID
, WSCT.TASK_ID) TASK_NAME
, WSCT.USER_ID
, WMS_RULES_WORKBENCH_PVT.GET_USER_NAME(WSCT.USER_ID) USER_NAME
, WSCT.TRANSACTION_ACTION_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_ACTION_NAME(WSCT.TRANSACTION_ACTION_ID) TRANSACTION_ACTION_NAME
, WSCT.REASON_ID
, WMS_RULES_WORKBENCH_PVT.GET_REASON_NAME(WSCT.REASON_ID) REASON_NAME
, WSCT.TRANSACTION_SOURCE_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_SOURCE_NAME(WSCT.TRANSACTION_SOURCE_TYPE_ID) TRANSACTION_SOURCE_TYPE_NAME
, WSCT.TRANSACTION_TYPE_ID
, WMS_RULES_WORKBENCH_PVT.GET_TRANSACTION_TYPE_NAME(WSCT.TRANSACTION_TYPE_ID) TRANSACTION_TYPE_NAME
, WSCT.UOM_CODE
, WMS_RULES_WORKBENCH_PVT.GET_UNIT_OF_MEASURE(WSCT.UOM_CODE) UNIT_OF_MEASURE
, WSCT.UOM_CLASS
, WMS_RULES_WORKBENCH_PVT.GET_UOM_CLASS_NAME(WSCT.UOM_CLASS) UOM_CLASS_NAME
, WSCT.LAST_UPDATE_DATE
, WSCT.CREATED_BY
, WSCT.CREATION_DATE
, WSCT.LAST_UPDATE_LOGIN
, WSCT.LAST_UPDATED_BY
, NULL WMS_ENABLED_FLAG
, WSCT.LOCATION_ID
, WMS_RULES_WORKBENCH_PVT.GET_LOCATION_NAME(WSCT.LOCATION_ID) LOCATION_NAME
FROM WMS_SELECTION_CRITERIA_TXN WSCT
WHERE WSCT.RETURN_TYPE_CODE = 'V'

Columns

Name
STG_ASSIGNMENT_ID
SEQUENCE_NUMBER
RULE_TYPE_CODE
RULE_TYPE
RETURN_TYPE
RETURN_TYPE_ID
RETURN_TYPE_NAME
ENABLED_FLAG
DATE_TYPE_CODE
DATE_TYPE_FROM
DATE_TYPE_TO
DATE_TYPE_LOOKUP_TYPE
EFFECTIVE_FROM
EFFECTIVE_TO
FROM_ORGANIZATION_ID
FROM_ORGANIZATION_CODE
FROM_SUBINVENTORY_NAME
TO_ORGANIZATION_ID
TO_ORGANIZATION_CODE
TO_SUBINVENTORY_NAME
CUSTOMER_ID
CUSTOMER_NAME
FREIGHT_CODE
FREIGHT_CODE_NAME
INVENTORY_ITEM_ID
ITEM
ITEM_TYPE
ITEM_TYPE_NAME
ASSIGNMENT_GROUP_ID
ABC_CLASS_ID
ABC_GROUP_CLASS_NAME
CATEGORY_SET_ID
CATEGORY_ID
CATEGORY_SET_NAME
ORDER_TYPE_ID
ORDER_TYPE_NAME
VENDOR_ID
VENDOR_NAME
PROJECT_ID
PROJECT_NAME
TASK_ID
TASK_NAME
USER_ID
USER_NAME
TRANSACTION_ACTION_ID
TRANSACTION_ACTION_NAME
REASON_ID
REASON_NAME
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_SOURCE_TYPE_NAME
TRANSACTION_TYPE_ID
TRANSACTION_TYPE_NAME
UOM_CODE
UNIT_OF_MEASURE
UOM_CLASS
UOM_CLASS_NAME
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
WMS_ENABLED_FLAG
LOCATION_ID
LOCATION_NAME