VIEW: GMD.FM_IBOM_HDR#

Source

View Text - Preformatted

select TOP_FORMULA_ID TOP_FORMULA_ID, ITEM_ID ITEM_ID, SCALE_PERCENT SCALE_PERCENT, FORMULA_USE FORMULA_USE, EFFECTIVITY_DATE EFFECTIVITY_DATE, FORMULA_QTY FORMULA_QTY, REPORT_QTY REPORT_QTY, REPORT_UOM REPORT_UOM, USE_INACTIVE_FLAG USE_INACTIVE_FLAG, MAX_EXPLODE_LEVELS MAX_EXPLODE_LEVELS, EXPLODED_BY EXPLODED_BY, EXPLODED_DATE EXPLODED_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, STATUS_CODE STATUS_CODE, ORGN_CODE ORGN_CODE, VALIDITY_ORGANIZATION_TYPE VALIDITY_ORGANIZATION_TYPE, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DISPLAY_QTY DISPLAY_QTY, EXPLODE_IND EXPLODE_IND, SCALE_ALLOWED SCALE_ALLOWED from "GMD"."FM_IBOM_HDR"

View Text - HTML Formatted

SELECT TOP_FORMULA_ID TOP_FORMULA_ID
, ITEM_ID ITEM_ID
, SCALE_PERCENT SCALE_PERCENT
, FORMULA_USE FORMULA_USE
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, FORMULA_QTY FORMULA_QTY
, REPORT_QTY REPORT_QTY
, REPORT_UOM REPORT_UOM
, USE_INACTIVE_FLAG USE_INACTIVE_FLAG
, MAX_EXPLODE_LEVELS MAX_EXPLODE_LEVELS
, EXPLODED_BY EXPLODED_BY
, EXPLODED_DATE EXPLODED_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, STATUS_CODE STATUS_CODE
, ORGN_CODE ORGN_CODE
, VALIDITY_ORGANIZATION_TYPE VALIDITY_ORGANIZATION_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DISPLAY_QTY DISPLAY_QTY
, EXPLODE_IND EXPLODE_IND
, SCALE_ALLOWED SCALE_ALLOWED
FROM "GMD"."FM_IBOM_HDR"