VIEW: APPS.WMS_SELECTION_CRITERIA_TXN_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'