[Home] [Help]
[Dependency Information]
[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#;
GME
GME_PARAMETERS
APPS
GME_PARAMETERS
|
|
|
|