DBA Data[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_SELECTION_CRITERIA_TXN

Object Details
Object Name: WMS_SELECTION_CRITERIA_TXN
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_SELECTION_CRITERIA_TXN
Subobject Name:
Status: VALID

Selection Criteria /Assignment Matrix Table

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: WMS_SELECTION_CRITERIA_TXN_PK1
  1. ColumnSTG_ASSIGNMENT_ID
Indexes
Index Type Uniqueness Tablespace Column
WMS_SELECTION_CRITERIA_TXN_PK1 IOT - TOP UNIQUE TablespaceAPPS_TS_TX_DATA ColumnSTG_ASSIGNMENT_ID
WMS_SELECTION_CRITERIA_TXN_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_ORGANIZATION_ID
ColumnRULE_TYPE_CODE
ColumnENABLED_FLAG
Columns
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

Query Text

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;

Dependencies

[top of page]

WMS.WMS_SELECTION_CRITERIA_TXN does not reference any database object

WMS.WMS_SELECTION_CRITERIA_TXN is referenced by following:

SchemaAPPS
SynonymWMS_SELECTION_CRITERIA_TXN