[Home] [Help] [Dependency Information]
Object Name: | SY_WF_ITEM_ROLES |
---|---|
Object Type: | TABLE |
Owner: | GMI |
FND Design Data: | GMI.SY_WF_ITEM_ROLES |
Subobject Name: | |
Status: | VALID |
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SY_WF_ITEM_ROLES_UK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_ID
WHSE_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | Item ID from IC_ITEM_MST | |
ITEM_NO | VARCHAR2 | (32) | Item Number from IC_ITEM_MST | |
EXPIRY_ROLE_NAME | VARCHAR2 | (100) | Roles for Lot Expiry Notification | |
EXPIRY_ROLE_DISPLAY_NAME | VARCHAR2 | (240) | Display Name for the Expiry_Role_Name | |
RETEST_ROLE_NAME | VARCHAR2 | (100) | Roles for Lot Retest Notification | |
RETEST_ROLE_DISPLAY_NAME | VARCHAR2 | (240) | Display Name for the Retest_Role_Name | |
LOT_EXPIRY_NOTE | NUMBER | (3) | Number of days before lot expiry date, the notification will be sent | |
LOT_RETEST_NOTE | NUMBER | (3) | Number of days before lot retest date, the notification will be sent | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
WHSE_ITEM_ID | NUMBER | (10) | Warehouse Item ID from IC_ITEM_MST | |
WHSE_ITEM_NO | VARCHAR2 | (32) | Warehouse Item Number from IC_ITEM_MST |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ID
, ITEM_NO
, EXPIRY_ROLE_NAME
, EXPIRY_ROLE_DISPLAY_NAME
, RETEST_ROLE_NAME
, RETEST_ROLE_DISPLAY_NAME
, LOT_EXPIRY_NOTE
, LOT_RETEST_NOTE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, WHSE_ITEM_ID
, WHSE_ITEM_NO
FROM GMI.SY_WF_ITEM_ROLES;
GMI.SY_WF_ITEM_ROLES does not reference any database object
GMI.SY_WF_ITEM_ROLES is referenced by following:
|
|
|