DBA Data[Home] [Help]

VIEW: WSM.WSM_PARAMETERS#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, NEW_LOT_SEPARATOR NEW_LOT_SEPARATOR, JOB_COMPLETION_SEPARATOR JOB_COMPLETION_SEPARATOR, ALLOW_BACKWARD_MOVE_FLAG ALLOW_BACKWARD_MOVE_FLAG, DELETE_BACKWARD_FROM_FLAG DELETE_BACKWARD_FROM_FLAG, TRANSACTION_ACCOUNT_ID TRANSACTION_ACCOUNT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PLAN_CODE PLAN_CODE, LAST_OPERATION_SEQ_NUM LAST_OPERATION_SEQ_NUM, OP_SEQ_NUM_INCREMENT OP_SEQ_NUM_INCREMENT, COPRODUCTS_SUPPLY_DEFAULT COPRODUCTS_SUPPLY_DEFAULT, DEFAULT_ACCT_CLASS_CODE DEFAULT_ACCT_CLASS_CODE, INV_LOT_TXN_ENABLED INV_LOT_TXN_ENABLED, ESTIMATED_SCRAP_ACCOUNTING ESTIMATED_SCRAP_ACCOUNTING, HONOR_KANBAN_SIZE HONOR_KANBAN_SIZE, CHARGE_JUMP_FROM_QUEUE CHARGE_JUMP_FROM_QUEUE, MOVE_IN_OPTION MOVE_IN_OPTION, MOVE_TO_NEXT_OP_OPTION MOVE_TO_NEXT_OP_OPTION, SHOW_NEXT_OP_BY_DEFAULT SHOW_NEXT_OP_BY_DEFAULT, TRACK_MULTI_USAGE_DATES TRACK_MULTI_USAGE_DATES, REUSE_JOBNAME REUSE_JOBNAME from "WSM"."WSM_PARAMETERS"
View Text - HTML Formatted

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