[Home] [Help] [Dependency Information]
Object Name: | WMS_BFLOW_LABEL_TYPE |
---|---|
Object Type: | TABLE |
Owner: | WMS |
FND Design Data: | WMS.WMS_BFLOW_LABEL_TYPE |
Subobject Name: | |
Status: | VALID |
This table stores the business flow to label types relationship. This relationship is mandatory for labels to print from business processes like receipt, inspection, cross dock and so on and so forth.
Please refer to the WMS documentation for a list of valid business flows.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WMS_BFLOW_LABEL_TYPE_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
BUSINESS_FLOW_CODE
DOCUMENT_ID LEVEL_TYPE_CODE LEVEL_VALUE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_FLOW_CODE | NUMBER | Yes | Unique Business Flow Identifier | |
DOCUMENT_ID | NUMBER | Yes | Label Type ID. | |
LEVEL_TYPE_CODE | NUMBER | Yes | This indicates the level at which the business flow to label type relationship exists. The various levels are Site, Responsibility, Application and User. | |
LEVEL_VALUE_ID | NUMBER | Yes | This indicates the level at which the business flow to label type relationship exists. The various levels are Site, Responsibility, Application and User. | |
COMMENTS | VARCHAR2 | (240) | Comments | |
ENABLED_FLAG | VARCHAR2 | (1) | Enabled Flag | |
DELIVERY_COMPLETE_FLAG | VARCHAR2 | (1) | 'Y' indicates that the printing should be postponed until the delivery is completely staged . To be used only for business flow codes of 6(cross dock ) and 19(pick drop) | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
REQUEST_ID | NUMBER | Concurrent WHO Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent WHO Column | ||
PROGRAM_ID | NUMBER | Concurrent WHO Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent WHO Column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flex Field Category | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Desc FF | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flex Field Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flex Field Column |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_FLOW_CODE
, DOCUMENT_ID
, LEVEL_TYPE_CODE
, LEVEL_VALUE_ID
, COMMENTS
, ENABLED_FLAG
, DELIVERY_COMPLETE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM WMS.WMS_BFLOW_LABEL_TYPE;
WMS.WMS_BFLOW_LABEL_TYPE does not reference any database object
WMS.WMS_BFLOW_LABEL_TYPE is referenced by following:
|
|
|