[Home] [Help] [Dependency Information]
Object Name: | WSM_RESPONSIBILITY_SETTINGS |
---|---|
Object Type: | TABLE |
Owner: | WSM |
Subobject Name: | |
Status: | VALID |
Stores the transactions and changes to a transaction allowed for a responsibility
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSM_RESPONSIBILITY_SETTINGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RESPONSIBILITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESPONSIBILITY_ID | NUMBER | Responsibility Identifier | ||
CONFIG_DISPATCH_LIST | NUMBER | Flag to indicate if the responsiiblity allows changing the dispatch list | ||
CHANGE_PLAN_DETAILS | NUMBER | Flag to indicate if the responsiiblity allows changing the plan details | ||
UNDO | NUMBER | Flag to indicate if the responsiiblity allows performing an undo transaction | ||
JUMP | NUMBER | Indicate whether Jump is allowed or not | ||
JUMP_INSIDE_ROUTING | NUMBER | Flag to indicate if the responsiiblity allows jump transaction to an operation inside the routing | ||
JUMP_OUTSIDE_ROUTING | NUMBER | Flag to indicate if the responsiiblity allows jump transaction to an operation outside the routing | ||
SPLIT_JOB | NUMBER | Flag to indicate if the responsiiblity allows a split transaction | ||
MERGE_JOBS | NUMBER | Flag to indicate if the responsiiblity allows a merge transaction | ||
UPDATE_ASSEMBLY | NUMBER | Flag to indicate if the responsiiblity allows an update assembly transaction | ||
UPDATE_ROUTING | NUMBER | Flag to indicate if the responsiiblity allows an update routing transaction | ||
UPDATE_QUANTITY | NUMBER | Flag to indicate if the responsiiblity allows an update quantity transaction | ||
UPDATE_LOT_NAME | NUMBER | Flag to indicate if the responsiiblity allows an update lot name transaction | ||
TRANSACT_MATERIAL | NUMBER | Flag to indicate if the responsiiblity allows material transaction | ||
COMP_SUBSTITUTE | NUMBER | Flag to indicate if the responsiiblity allows component substitution during a move transaction | ||
COMP_CHANGE_BACKFLUSH | NUMBER | Flag to indicate if the responsiiblity allows changing the components backflushed during a move transaction | ||
CODE_MASK | NUMBER | Internal column used for retrieving responsibility settings | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when the row was last updated | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) | ||
CREATION_DATE | DATE | Standard Who column - date when the row was created | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
Cut, paste (and edit) the following text to query this object:
SELECT RESPONSIBILITY_ID
, CONFIG_DISPATCH_LIST
, CHANGE_PLAN_DETAILS
, UNDO
, JUMP
, JUMP_INSIDE_ROUTING
, JUMP_OUTSIDE_ROUTING
, SPLIT_JOB
, MERGE_JOBS
, UPDATE_ASSEMBLY
, UPDATE_ROUTING
, UPDATE_QUANTITY
, UPDATE_LOT_NAME
, TRANSACT_MATERIAL
, COMP_SUBSTITUTE
, COMP_CHANGE_BACKFLUSH
, CODE_MASK
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM WSM.WSM_RESPONSIBILITY_SETTINGS;
WSM.WSM_RESPONSIBILITY_SETTINGS does not reference any database object
WSM.WSM_RESPONSIBILITY_SETTINGS is referenced by following:
|
|
|