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

VIEW: APPS.WMS_SELECTION_CRITERIA_TXN_V

Object Details
Object Name: WMS_SELECTION_CRITERIA_TXN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_SELECTION_CRITERIA_TXN_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
STG_ASSIGNMENT_ID NUMBER

Strategy Assigment Identifier - Unique Identifier for each Assignemnt in the Assignment Matrix
SEQUENCE_NUMBER NUMBER

Sequence Number
RULE_TYPE_CODE NUMBER

Rule Type
RULE_TYPE VARCHAR2 (16)
Rule Type
RETURN_TYPE VARCHAR2 (1)
Return Type
RETURN_TYPE_ID NUMBER

Return Type
RETURN_TYPE_NAME VARCHAR2 (4000)
Return Type Name
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

Source Organization Identifier
FROM_ORGANIZATION_CODE VARCHAR2 (4000)
Source Organization Code
FROM_SUBINVENTORY_NAME VARCHAR2 (10)
Source Subinventory Name
TO_ORGANIZATION_ID NUMBER

Destination Organization Identifier
TO_ORGANIZATION_CODE VARCHAR2 (4000)
Destination Organization Code
TO_SUBINVENTORY_NAME VARCHAR2 (10)
Destination Subinventory Name
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_NAME VARCHAR2 (4000)
Customer Name
FREIGHT_CODE VARCHAR2 (25)
Freight Code
FREIGHT_CODE_NAME VARCHAR2 (4000)
Freight Code Name
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM VARCHAR2 (4000)
Inventory Item name
ITEM_TYPE VARCHAR2 (30)
Inventory Item Type
ITEM_TYPE_NAME VARCHAR2 (4000)
Item Type Name
ASSIGNMENT_GROUP_ID NUMBER

Assignment Group Identifier
ABC_CLASS_ID NUMBER

ABC Class Identifier
ABC_GROUP_CLASS_NAME VARCHAR2 (4000)
Assignment Group Identifier
CATEGORY_SET_ID NUMBER

category set Identifier
CATEGORY_ID NUMBER

Item category Identifier
CATEGORY_SET_NAME VARCHAR2 (4000)
Item category Set Name
ORDER_TYPE_ID NUMBER

Order Type Identifier
ORDER_TYPE_NAME VARCHAR2 (4000)
Order Type Name
VENDOR_ID NUMBER

Vendor Identifier
VENDOR_NAME VARCHAR2 (4000)
Vendor Name
PROJECT_ID NUMBER

Project Identifier
PROJECT_NAME VARCHAR2 (4000)
Project Name
TASK_ID NUMBER

Task Identifier
TASK_NAME VARCHAR2 (4000)
Task Name
USER_ID NUMBER

User Identifier
USER_NAME VARCHAR2 (4000)
User Name
TRANSACTION_ACTION_ID NUMBER

Transaction Action Identifier
TRANSACTION_ACTION_NAME VARCHAR2 (4000)
Transaction Action Code
REASON_ID NUMBER

Reason Identifier
REASON_NAME VARCHAR2 (4000)
Reason Name
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction Source Type Identifier
TRANSACTION_SOURCE_TYPE_NAME VARCHAR2 (4000)
Transaction Source Type Name
TRANSACTION_TYPE_ID NUMBER

Transaction Type Identifier
TRANSACTION_TYPE_NAME VARCHAR2 (4000)
Transaction Type Name
UOM_CODE VARCHAR2 (3)
UOM CODE
UNIT_OF_MEASURE VARCHAR2 (4000)
Unit OF Measure
UOM_CLASS VARCHAR2 (10)
UOM Class
UOM_CLASS_NAME VARCHAR2 (4000)
UOM Class Name
LAST_UPDATE_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
WMS_ENABLED_FLAG VARCHAR2 (1)
WMS Enabled Falg
LOCATION_ID NUMBER

Location Identifier
LOCATION_NAME VARCHAR2 (4000)
Location Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.WMS_SELECTION_CRITERIA_TXN_V;

Dependencies

[top of page]

APPS.WMS_SELECTION_CRITERIA_TXN_V references the following:

SchemaAPPS
SynonymWMS_RULES_B
PL/SQL PackageWMS_RULES_WORKBENCH_PVT - show dependent code
SynonymWMS_SELECTION_CRITERIA_TXN
SynonymWMS_STRATEGIES_B
APPS.WMS_SELECTION_CRITERIA_TXN_V is referenced by following:

SchemaAPPS
Package BodyWMS_CARTNZN_PUB - show dependent code
Package BodyWMS_POSTALLOC_PVT - show dependent code