[Home] [Help] [Dependency Information]
Object Name: | GME_PARAMETERS# |
---|---|
Object Type: | VIEW |
Owner: | GME |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IB_FACTOR_IND | NUMBER | (1) | ||
ORGANIZATION_ID | NUMBER | Yes | ||
AUTO_CONSUME_SUPPLY_SUB_ONLY | NUMBER | (1) | Yes | |
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | ||
SUPPLY_LOCATOR_ID | NUMBER | |||
YIELD_SUBINVENTORY | VARCHAR2 | (10) | ||
YIELD_LOCATOR_ID | NUMBER | |||
DELETE_MATERIAL_IND | NUMBER | (1) | Yes | |
VALIDATE_PLAN_DATES_IND | NUMBER | (1) | Yes | |
DISPLAY_UNCONSUMED_MATERIAL | NUMBER | (1) | Yes | |
STEP_CONTROLS_BATCH_STS_IND | NUMBER | (1) | Yes | |
BACKFLUSH_RSRC_USG_IND | NUMBER | (1) | Yes | |
DEF_ACTUAL_RSRC_USG_IND | NUMBER | (1) | Yes | |
CALC_INTERIM_RSRC_USG_IND | NUMBER | (1) | Yes | |
ALLOW_QTY_BELOW_MIN_IND | NUMBER | (1) | Yes | |
DISPLAY_NON_WORK_DAYS_IND | NUMBER | (1) | Yes | |
CHECK_SHORTAGES_IND | NUMBER | (1) | Yes | |
COPY_FORMULA_TEXT_IND | NUMBER | (1) | Yes | |
COPY_ROUTING_TEXT_IND | NUMBER | (1) | Yes | |
CREATE_HIGH_LEVEL_RESV_IND | NUMBER | (1) | Yes | |
CREATE_MOVE_ORDERS_IND | NUMBER | (1) | Yes | |
RESERVATION_TIMEFENCE | NUMBER | (5) | ||
MOVE_ORDER_TIMEFENCE | NUMBER | (5) | ||
BATCH_DOC_NUMBERING | NUMBER | (1) | ||
BATCH_NO_LAST_ASSIGNED | NUMBER | (10) | ||
FPO_DOC_NUMBERING | NUMBER | (1) | ||
FPO_NO_LAST_ASSIGNED | NUMBER | (10) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
RULE_BASED_RESV_HORIZON | NUMBER | |||
INGR_SUB_DATE | NUMBER | (1) | ||
SUBINV_LOC_IND | NUMBER | (1) | ||
GROUP_DOC_NUMBERING | NUMBER | (1) | ||
GROUP_LAST_ASSIGNED | NUMBER | (10) | ||
FIXED_PROCESS_LOSS_IND | NUMBER | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT IB_FACTOR_IND
, ORGANIZATION_ID
, AUTO_CONSUME_SUPPLY_SUB_ONLY
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, YIELD_SUBINVENTORY
, YIELD_LOCATOR_ID
, DELETE_MATERIAL_IND
, VALIDATE_PLAN_DATES_IND
, DISPLAY_UNCONSUMED_MATERIAL
, STEP_CONTROLS_BATCH_STS_IND
, BACKFLUSH_RSRC_USG_IND
, DEF_ACTUAL_RSRC_USG_IND
, CALC_INTERIM_RSRC_USG_IND
, ALLOW_QTY_BELOW_MIN_IND
, DISPLAY_NON_WORK_DAYS_IND
, CHECK_SHORTAGES_IND
, COPY_FORMULA_TEXT_IND
, COPY_ROUTING_TEXT_IND
, CREATE_HIGH_LEVEL_RESV_IND
, CREATE_MOVE_ORDERS_IND
, RESERVATION_TIMEFENCE
, MOVE_ORDER_TIMEFENCE
, BATCH_DOC_NUMBERING
, BATCH_NO_LAST_ASSIGNED
, FPO_DOC_NUMBERING
, FPO_NO_LAST_ASSIGNED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RULE_BASED_RESV_HORIZON
, INGR_SUB_DATE
, SUBINV_LOC_IND
, GROUP_DOC_NUMBERING
, GROUP_LAST_ASSIGNED
, FIXED_PROCESS_LOSS_IND
FROM GME.GME_PARAMETERS#;
|
|
|