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

TABLE: WSM.WSM_PARAMETERS

Object Details
Object Name: WSM_PARAMETERS
Object Type: TABLE
Owner: WSM
FND Design Data: TableWSM.WSM_PARAMETERS
Subobject Name:
Status: VALID


Define OSFM Parameters for a Inventory/Manufacturing Organization


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSM_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes OSFM Organization Identifier.(PK)
NEW_LOT_SEPARATOR VARCHAR2 (1)
New Lot Separator. (used by OSFM Transactions)
JOB_COMPLETION_SEPARATOR VARCHAR2 (1)
Lot based Job completion separator
ALLOW_BACKWARD_MOVE_FLAG NUMBER

Flag to set to Allow UNDO Last Lot Job Move.
DELETE_BACKWARD_FROM_FLAG NUMBER

Not used.
TRANSACTION_ACCOUNT_ID NUMBER (15)
ransaction Account Id used for Lot Transactions.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created 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).
PLAN_CODE VARCHAR2 (30)
Quality Plan Code. (Not used currently)
LAST_OPERATION_SEQ_NUM NUMBER

Last Operation Sequence Number for a Lot based Job. Default to 9999.
OP_SEQ_NUM_INCREMENT NUMBER

Operation Sequence Number Increment for Lot Job Moves. Defaults to 10.
COPRODUCTS_SUPPLY_DEFAULT NUMBER

Default for lot job to consider associated co-products as supply.
DEFAULT_ACCT_CLASS_CODE VARCHAR2 (10)
Default account class code (used by Lot based Job creation).
INV_LOT_TXN_ENABLED NUMBER

Flag to allow inventory lot transaction
ESTIMATED_SCRAP_ACCOUNTING NUMBER

Flag indicating whether estimate scrap accounting will be conducted for the organization
HONOR_KANBAN_SIZE NUMBER

Honor Item's Kanban size for Lot based Jobs Replenishment
CHARGE_JUMP_FROM_QUEUE NUMBER

To charge jump-from-queue operation or not
MOVE_IN_OPTION NUMBER

Allow Move In transaction for the current Organization.
MOVE_TO_NEXT_OP_OPTION NUMBER

Allow Move to Next Operation for the Current Organization.
SHOW_NEXT_OP_BY_DEFAULT NUMBER

Flag Which Decides Behaviour of Move to Next Operation
TRACK_MULTI_USAGE_DATES NUMBER

Track Multiple Resource Usage (Currently Not Used).
REUSE_JOBNAME NUMBER
Yes Parameter to allow creation of new jobs with name same as that of existing lot.
Query Text

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


SELECT ORGANIZATION_ID
,      NEW_LOT_SEPARATOR
,      JOB_COMPLETION_SEPARATOR
,      ALLOW_BACKWARD_MOVE_FLAG
,      DELETE_BACKWARD_FROM_FLAG
,      TRANSACTION_ACCOUNT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_CODE
,      LAST_OPERATION_SEQ_NUM
,      OP_SEQ_NUM_INCREMENT
,      COPRODUCTS_SUPPLY_DEFAULT
,      DEFAULT_ACCT_CLASS_CODE
,      INV_LOT_TXN_ENABLED
,      ESTIMATED_SCRAP_ACCOUNTING
,      HONOR_KANBAN_SIZE
,      CHARGE_JUMP_FROM_QUEUE
,      MOVE_IN_OPTION
,      MOVE_TO_NEXT_OP_OPTION
,      SHOW_NEXT_OP_BY_DEFAULT
,      TRACK_MULTI_USAGE_DATES
,      REUSE_JOBNAME
FROM WSM.WSM_PARAMETERS;

Dependencies

[top of page]

WSM.WSM_PARAMETERS does not reference any database object

WSM.WSM_PARAMETERS is referenced by following:

SchemaAPPS
SynonymWSM_PARAMETERS