[Home] [Help] [Dependency Information]
Object Name: | WMS_SELECTION_CRITERIA_TXN |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_SELECTION_CRITERIA_TXN |
Subobject Name: | |
Status: | VALID |
Selection Criteria /Assignment Matrix Table
Tablespace: | |
---|---|
PCT Free: | 0 |
PCT Used: | 0 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_SELECTION_CRITERIA_TXN_PK1 | IOT - TOP | UNIQUE | APPS_TS_TX_DATA | STG_ASSIGNMENT_ID |
WMS_SELECTION_CRITERIA_TXN_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FROM_ORGANIZATION_ID
RULE_TYPE_CODE ENABLED_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STG_ASSIGNMENT_ID | NUMBER | Yes | ||
SEQUENCE_NUMBER | NUMBER | Yes | Sequence Number | |
RULE_TYPE_CODE | NUMBER | Yes | Rule Type | |
RETURN_TYPE_CODE | VARCHAR2 | (1) | Yes | Return Type |
RETURN_TYPE_ID | NUMBER | Return Type identifier | ||
ENABLED_FLAG | VARCHAR2 | (1) | Enabled Flag | |
DATE_TYPE_CODE | VARCHAR2 | (30) | Date Type Code | |
DATE_TYPE_FROM | NUMBER | Date Type From | ||
DATE_TYPE_TO | NUMBER | Date Type To | ||
DATE_TYPE_LOOKUP_TYPE | VARCHAR2 | (30) | Date Type Lookup type | |
EFFECTIVE_FROM | DATE | Effective From Date | ||
EFFECTIVE_TO | DATE | Effective To Date | ||
FROM_ORGANIZATION_ID | NUMBER | Yes | Source Organization Identifier | |
FROM_SUBINVENTORY_NAME | VARCHAR2 | (10) | Source Subinventory Name | |
TO_ORGANIZATION_ID | NUMBER | Destination Organization Identifier | ||
TO_SUBINVENTORY_NAME | VARCHAR2 | (10) | Destination Subinventory Name | |
CUSTOMER_ID | NUMBER | Customer Identifier | ||
FREIGHT_CODE | VARCHAR2 | (25) | Freight Code | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
ITEM_TYPE | VARCHAR2 | (30) | Item Type | |
ASSIGNMENT_GROUP_ID | NUMBER | Assignment Group Identifier | ||
ABC_CLASS_ID | NUMBER | ABC Class Identifier | ||
CATEGORY_SET_ID | NUMBER | category set Identifier | ||
CATEGORY_ID | NUMBER | category Identifier | ||
ORDER_TYPE_ID | NUMBER | Order Type Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
PROJECT_ID | NUMBER | Project Identifier | ||
TASK_ID | NUMBER | Task Identifier | ||
USER_ID | NUMBER | User Identifier | ||
TRANSACTION_ACTION_ID | NUMBER | Transaction Action Identifier | ||
REASON_ID | NUMBER | Reason Identifier | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction Type Identifier | ||
TRANSACTION_TYPE_ID | NUMBER | Transaction Type Identifier | ||
UOM_CODE | VARCHAR2 | (3) | UOM CODE | |
UOM_CLASS | VARCHAR2 | (10) | UOM Class Identifier | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LOCATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT STG_ASSIGNMENT_ID
, SEQUENCE_NUMBER
, RULE_TYPE_CODE
, RETURN_TYPE_CODE
, RETURN_TYPE_ID
, ENABLED_FLAG
, DATE_TYPE_CODE
, DATE_TYPE_FROM
, DATE_TYPE_TO
, DATE_TYPE_LOOKUP_TYPE
, EFFECTIVE_FROM
, EFFECTIVE_TO
, FROM_ORGANIZATION_ID
, FROM_SUBINVENTORY_NAME
, TO_ORGANIZATION_ID
, TO_SUBINVENTORY_NAME
, CUSTOMER_ID
, FREIGHT_CODE
, INVENTORY_ITEM_ID
, ITEM_TYPE
, ASSIGNMENT_GROUP_ID
, ABC_CLASS_ID
, CATEGORY_SET_ID
, CATEGORY_ID
, ORDER_TYPE_ID
, VENDOR_ID
, PROJECT_ID
, TASK_ID
, USER_ID
, TRANSACTION_ACTION_ID
, REASON_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_TYPE_ID
, UOM_CODE
, UOM_CLASS
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LOCATION_ID
FROM WMS.WMS_SELECTION_CRITERIA_TXN;
WMS.WMS_SELECTION_CRITERIA_TXN does not reference any database object
WMS.WMS_SELECTION_CRITERIA_TXN is referenced by following:
|
|
|