VIEW: WMS.WMS_SELECTION_CRITERIA_TXN#

Source

View Text - Preformatted

select STG_ASSIGNMENT_ID STG_ASSIGNMENT_ID, SEQUENCE_NUMBER SEQUENCE_NUMBER, RULE_TYPE_CODE RULE_TYPE_CODE, RETURN_TYPE_CODE RETURN_TYPE_CODE, RETURN_TYPE_ID RETURN_TYPE_ID, ENABLED_FLAG ENABLED_FLAG, DATE_TYPE_CODE DATE_TYPE_CODE, DATE_TYPE_FROM DATE_TYPE_FROM, DATE_TYPE_TO DATE_TYPE_TO, DATE_TYPE_LOOKUP_TYPE DATE_TYPE_LOOKUP_TYPE, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, FROM_SUBINVENTORY_NAME FROM_SUBINVENTORY_NAME, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, TO_SUBINVENTORY_NAME TO_SUBINVENTORY_NAME, CUSTOMER_ID CUSTOMER_ID, FREIGHT_CODE FREIGHT_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_TYPE ITEM_TYPE, ASSIGNMENT_GROUP_ID ASSIGNMENT_GROUP_ID, ABC_CLASS_ID ABC_CLASS_ID, CATEGORY_SET_ID CATEGORY_SET_ID, CATEGORY_ID CATEGORY_ID, ORDER_TYPE_ID ORDER_TYPE_ID, VENDOR_ID VENDOR_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, USER_ID USER_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, REASON_ID REASON_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, UOM_CODE UOM_CODE, UOM_CLASS UOM_CLASS, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOCATION_ID LOCATION_ID from "WMS"."WMS_SELECTION_CRITERIA_TXN"

View Text - HTML Formatted

SELECT STG_ASSIGNMENT_ID STG_ASSIGNMENT_ID
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, RULE_TYPE_CODE RULE_TYPE_CODE
, RETURN_TYPE_CODE RETURN_TYPE_CODE
, RETURN_TYPE_ID RETURN_TYPE_ID
, ENABLED_FLAG ENABLED_FLAG
, DATE_TYPE_CODE DATE_TYPE_CODE
, DATE_TYPE_FROM DATE_TYPE_FROM
, DATE_TYPE_TO DATE_TYPE_TO
, DATE_TYPE_LOOKUP_TYPE DATE_TYPE_LOOKUP_TYPE
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, FROM_SUBINVENTORY_NAME FROM_SUBINVENTORY_NAME
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, TO_SUBINVENTORY_NAME TO_SUBINVENTORY_NAME
, CUSTOMER_ID CUSTOMER_ID
, FREIGHT_CODE FREIGHT_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_TYPE ITEM_TYPE
, ASSIGNMENT_GROUP_ID ASSIGNMENT_GROUP_ID
, ABC_CLASS_ID ABC_CLASS_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, VENDOR_ID VENDOR_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, USER_ID USER_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, REASON_ID REASON_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, UOM_CODE UOM_CODE
, UOM_CLASS UOM_CLASS
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOCATION_ID LOCATION_ID
FROM "WMS"."WMS_SELECTION_CRITERIA_TXN"