[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GME_PARAMETERS |
|---|---|
| Object Type: | TABLE |
| Owner: | GME |
| FND Design Data: |  GME.GME_PARAMETERS
|
| Subobject Name: | |
| Status: | VALID |
This is a new table that holds all the GME parameters at the org level
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GME_PARAMETERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORGANIZATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IB_FACTOR_IND | NUMBER | (1) | IB Factor Calculation indicator 1 - Total Products0 - Single Material | |
| ORGANIZATION_ID | NUMBER | Yes | The organization for which the parameters are defined. | |
| AUTO_CONSUME_SUPPLY_SUB_ONLY | NUMBER | (1) | Yes | For Automatic consumption ingredients. Indicates whether consumption can be done only from Supply subinv. Or any subinv.1=Auto Consume from Supply Subinv. only.0 = Can consume from other subinv. |
| SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Default Supply subinv for ingredients. | |
| SUPPLY_LOCATOR_ID | NUMBER | Default Supply locator for the default Supply subinv. | ||
| YIELD_SUBINVENTORY | VARCHAR2 | (10) | Default Yield subinv. For products, byproducts | |
| YIELD_LOCATOR_ID | NUMBER | Default Yield locator for the default Yield subinv. | ||
| DELETE_MATERIAL_IND | NUMBER | (1) | Yes | Indicates the stages of a production batch which will allow material deletion.1 = Pending, 2 = Pending and Wip |
| VALIDATE_PLAN_DATES_IND | NUMBER | (1) | Yes | Determines whether to validate the planned start/completion dates against the validity rule.1 = Validate both planned dates. 2 = Validate planned start date only. |
| DISPLAY_UNCONSUMED_MATERIAL | NUMBER | (1) | Yes | Determines whether unconsumed ingredients,unyielded products will be displayed during release/complete of batch.1 = Display unconsumed,unyielded items.0 = Don't display unconsumed,unyielded items. |
| STEP_CONTROLS_BATCH_STS_IND | NUMBER | (1) | Yes | Determines if batch status is set per as the step status. 1= Batch status is appropriately based on step status. Eg. If batch is pending and a step is released then the batch status is also changed to wip.0= Batch status is independent of step status and is not controlled by it. Eg. User will not be able to release step unless batch is released. |
| BACKFLUSH_RSRC_USG_IND | NUMBER | (1) | Yes | Indicates whether resource usage will be backflushed during incremental backflushing.1=Resource usage will be backflushed.0=Resource usage will not be backflushed |
| DEF_ACTUAL_RSRC_USG_IND | NUMBER | (1) | Yes | Determines whether the planned resource usage is copied to the actual resource usage.1=Actual usage will be defaulted to the Planned usage.0=Actual usage will not default to the Planned usage. |
| CALC_INTERIM_RSRC_USG_IND | NUMBER | (1) | Yes | Indicates whether the actual step quantity and resource usages will be calculated when the step is in WIP stage.1=Resource usage will be calculated.0=Resource usage will not be calculated. |
| ALLOW_QTY_BELOW_MIN_IND | NUMBER | (1) | Yes | Determines if the user can enter a resource process quantity that is less than the resource capacity.1=Allow process quantity less than resource capacity.0=Don't allow. |
| DISPLAY_NON_WORK_DAYS_IND | NUMBER | (1) | Yes | Determines whether the non working days will be indicated in the production scheduler.1=Indicate non working days.0=Don't indicate non working days. |
| CHECK_SHORTAGES_IND | NUMBER | (1) | Yes | Determines whether the inventory shortage check will be performed during the batch create process.1=Check shortages during batch creation.0=Don't check for shortages |
| COPY_FORMULA_TEXT_IND | NUMBER | (1) | Yes | Indicates whether the formula text will be copied to the batch.1=Formula text will be copied.0=Formula text will not be copied. |
| COPY_ROUTING_TEXT_IND | NUMBER | (1) | Yes | Indicates whether the routing text will be copied to the batch1=Routing text will be copied.0=Routing text will not be copied. |
| CREATE_HIGH_LEVEL_RESV_IND | NUMBER | (1) | Yes | Indicates whether creation of high-level Reservations is allowed during the batch create process.1=Allow creation of High Level Reservations during batch creation.0=No High Level Reservations will be created during batch creation. |
| CREATE_MOVE_ORDERS_IND | NUMBER | (1) | Yes | Indicates whether creation of move orders is allowed during the batch create process. 1=Allow creation of Move Orders during batch creation.0=No Move Orders will be created during batch creation. |
| RESERVATION_TIMEFENCE | NUMBER | (5) | Used to determine if the material plan dates are within the time fence to create High level Reservations during batch create. | |
| MOVE_ORDER_TIMEFENCE | NUMBER | (5) | Used to determine if the material plan dates are within the time fence to create Move Orders during batch create | |
| BATCH_DOC_NUMBERING | NUMBER | (1) | Indicates the Document Ordering type for Production batches.1=Manual.2=Automatic | |
| BATCH_NO_LAST_ASSIGNED | NUMBER | (10) | Indicates the last batch number that was assigned using Automatic numbering. | |
| FPO_DOC_NUMBERING | NUMBER | (1) | Indicates the Document Ordering type for Firm Planned Orders (FPO). 1=Manual.2=Automatic. | |
| FPO_NO_LAST_ASSIGNED | NUMBER | (10) | Indicates the last FPO number that was assigned using Automatic numbering. | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | Yes | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| RULE_BASED_RESV_HORIZON | NUMBER | This is the horizon used for rule based reservations | ||
| INGR_SUB_DATE | NUMBER | (1) | Indicates which date to use for ingredient substitution. | |
| SUBINV_LOC_IND | NUMBER | (1) | Indicates whether to show only subinventories/locators with onhand | |
| GROUP_DOC_NUMBERING | NUMBER | (1) | This is the column for group numbering type | |
| GROUP_LAST_ASSIGNED | NUMBER | (10) | This is the column for the last assigned group number for automatic group numbering | |
| FIXED_PROCESS_LOSS_IND | NUMBER | (1) | The column specifies if fixed process loss will be applied manually or to set of batches when creating a batch |
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 does not reference any database object
GME.GME_PARAMETERS is referenced by following:
APPS
GME_PARAMETERS
|
|
|
|