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

VIEW: WSM.WSM_PARAMETERS#

Object Details
Object Name: WSM_PARAMETERS#
Object Type: VIEW
Owner: WSM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes
NEW_LOT_SEPARATOR VARCHAR2 (1)
JOB_COMPLETION_SEPARATOR VARCHAR2 (1)
ALLOW_BACKWARD_MOVE_FLAG NUMBER

DELETE_BACKWARD_FROM_FLAG NUMBER

TRANSACTION_ACCOUNT_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PLAN_CODE VARCHAR2 (30)
LAST_OPERATION_SEQ_NUM NUMBER

OP_SEQ_NUM_INCREMENT NUMBER

COPRODUCTS_SUPPLY_DEFAULT NUMBER

DEFAULT_ACCT_CLASS_CODE VARCHAR2 (10)
INV_LOT_TXN_ENABLED NUMBER

ESTIMATED_SCRAP_ACCOUNTING NUMBER

HONOR_KANBAN_SIZE NUMBER

CHARGE_JUMP_FROM_QUEUE NUMBER

MOVE_IN_OPTION NUMBER

MOVE_TO_NEXT_OP_OPTION NUMBER

SHOW_NEXT_OP_BY_DEFAULT NUMBER

TRACK_MULTI_USAGE_DATES NUMBER

REUSE_JOBNAME NUMBER
Yes
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# references the following:

SchemaWSM
TableWSM_PARAMETERS
WSM.WSM_PARAMETERS# is referenced by following:

SchemaAPPS
SynonymWSM_PARAMETERS