Skip to content

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

TABLE: WSM.WSM_RESPONSIBILITY_SETTINGS

Object Details
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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSM_RESPONSIBILITY_SETTINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSIBILITY_ID
Columns
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)
Query Text

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;

Dependencies

[top of page]

WSM.WSM_RESPONSIBILITY_SETTINGS does not reference any database object

WSM.WSM_RESPONSIBILITY_SETTINGS is referenced by following:

SchemaWSM
ViewWSM_RESPONSIBILITY_SETTINGS#