[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:
|
|
|