DBA Data[Home] [Help]

VIEW: GME.GME_PARAMETERS#

Source

View Text - Preformatted

select IB_FACTOR_IND IB_FACTOR_IND, ORGANIZATION_ID ORGANIZATION_ID, AUTO_CONSUME_SUPPLY_SUB_ONLY AUTO_CONSUME_SUPPLY_SUB_ONLY, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID, YIELD_SUBINVENTORY YIELD_SUBINVENTORY, YIELD_LOCATOR_ID YIELD_LOCATOR_ID, DELETE_MATERIAL_IND DELETE_MATERIAL_IND, VALIDATE_PLAN_DATES_IND VALIDATE_PLAN_DATES_IND, DISPLAY_UNCONSUMED_MATERIAL DISPLAY_UNCONSUMED_MATERIAL, STEP_CONTROLS_BATCH_STS_IND STEP_CONTROLS_BATCH_STS_IND, BACKFLUSH_RSRC_USG_IND BACKFLUSH_RSRC_USG_IND, DEF_ACTUAL_RSRC_USG_IND DEF_ACTUAL_RSRC_USG_IND, CALC_INTERIM_RSRC_USG_IND CALC_INTERIM_RSRC_USG_IND, ALLOW_QTY_BELOW_MIN_IND ALLOW_QTY_BELOW_MIN_IND, DISPLAY_NON_WORK_DAYS_IND DISPLAY_NON_WORK_DAYS_IND, CHECK_SHORTAGES_IND CHECK_SHORTAGES_IND, COPY_FORMULA_TEXT_IND COPY_FORMULA_TEXT_IND, COPY_ROUTING_TEXT_IND COPY_ROUTING_TEXT_IND, CREATE_HIGH_LEVEL_RESV_IND CREATE_HIGH_LEVEL_RESV_IND, CREATE_MOVE_ORDERS_IND CREATE_MOVE_ORDERS_IND, RESERVATION_TIMEFENCE RESERVATION_TIMEFENCE, MOVE_ORDER_TIMEFENCE MOVE_ORDER_TIMEFENCE, BATCH_DOC_NUMBERING BATCH_DOC_NUMBERING, BATCH_NO_LAST_ASSIGNED BATCH_NO_LAST_ASSIGNED, FPO_DOC_NUMBERING FPO_DOC_NUMBERING, FPO_NO_LAST_ASSIGNED FPO_NO_LAST_ASSIGNED, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RULE_BASED_RESV_HORIZON RULE_BASED_RESV_HORIZON, INGR_SUB_DATE INGR_SUB_DATE, SUBINV_LOC_IND SUBINV_LOC_IND, GROUP_DOC_NUMBERING GROUP_DOC_NUMBERING, GROUP_LAST_ASSIGNED GROUP_LAST_ASSIGNED, FIXED_PROCESS_LOSS_IND FIXED_PROCESS_LOSS_IND from "GME"."GME_PARAMETERS"
View Text - HTML Formatted

SELECT IB_FACTOR_IND IB_FACTOR_IND
, ORGANIZATION_ID ORGANIZATION_ID
, AUTO_CONSUME_SUPPLY_SUB_ONLY AUTO_CONSUME_SUPPLY_SUB_ONLY
, SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID
, YIELD_SUBINVENTORY YIELD_SUBINVENTORY
, YIELD_LOCATOR_ID YIELD_LOCATOR_ID
, DELETE_MATERIAL_IND DELETE_MATERIAL_IND
, VALIDATE_PLAN_DATES_IND VALIDATE_PLAN_DATES_IND
, DISPLAY_UNCONSUMED_MATERIAL DISPLAY_UNCONSUMED_MATERIAL
, STEP_CONTROLS_BATCH_STS_IND STEP_CONTROLS_BATCH_STS_IND
, BACKFLUSH_RSRC_USG_IND BACKFLUSH_RSRC_USG_IND
, DEF_ACTUAL_RSRC_USG_IND DEF_ACTUAL_RSRC_USG_IND
, CALC_INTERIM_RSRC_USG_IND CALC_INTERIM_RSRC_USG_IND
, ALLOW_QTY_BELOW_MIN_IND ALLOW_QTY_BELOW_MIN_IND
, DISPLAY_NON_WORK_DAYS_IND DISPLAY_NON_WORK_DAYS_IND
, CHECK_SHORTAGES_IND CHECK_SHORTAGES_IND
, COPY_FORMULA_TEXT_IND COPY_FORMULA_TEXT_IND
, COPY_ROUTING_TEXT_IND COPY_ROUTING_TEXT_IND
, CREATE_HIGH_LEVEL_RESV_IND CREATE_HIGH_LEVEL_RESV_IND
, CREATE_MOVE_ORDERS_IND CREATE_MOVE_ORDERS_IND
, RESERVATION_TIMEFENCE RESERVATION_TIMEFENCE
, MOVE_ORDER_TIMEFENCE MOVE_ORDER_TIMEFENCE
, BATCH_DOC_NUMBERING BATCH_DOC_NUMBERING
, BATCH_NO_LAST_ASSIGNED BATCH_NO_LAST_ASSIGNED
, FPO_DOC_NUMBERING FPO_DOC_NUMBERING
, FPO_NO_LAST_ASSIGNED FPO_NO_LAST_ASSIGNED
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RULE_BASED_RESV_HORIZON RULE_BASED_RESV_HORIZON
, INGR_SUB_DATE INGR_SUB_DATE
, SUBINV_LOC_IND SUBINV_LOC_IND
, GROUP_DOC_NUMBERING GROUP_DOC_NUMBERING
, GROUP_LAST_ASSIGNED GROUP_LAST_ASSIGNED
, FIXED_PROCESS_LOSS_IND FIXED_PROCESS_LOSS_IND
FROM "GME"."GME_PARAMETERS"