eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: GMF.GMF_BATCH_REQUIREMENTS#

Source

View Text - Preformatted


select VIB_ID VIB_ID, BATCH_ID BATCH_ID, PRODUCT_ITEM_ID PRODUCT_ITEM_ID, PROD_MATERIAL_DETAIL_ID PROD_MATERIAL_DETAIL_ID, BATCHSTEP_ID BATCHSTEP_ID, INGREDIENT_ITEM_ID INGREDIENT_ITEM_ID, ING_MATERIAL_DETAIL_ID ING_MATERIAL_DETAIL_ID, RESOURCES RESOURCES, BATCHSTEP_RESOURCE_ID BATCHSTEP_RESOURCE_ID, DERIVED_COST_ALLOC DERIVED_COST_ALLOC, REQUIRED_DOC_QTY REQUIRED_DOC_QTY, DELETE_MARK DELETE_MARK, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUIREMENT_ID REQUIREMENT_ID, ORGANIZATION_ID ORGANIZATION_ID, VIB_PROFILE_VALUE VIB_PROFILE_VALUE from "GMF"."GMF_BATCH_REQUIREMENTS"

View Text - HTML Formatted

SELECT VIB_ID VIB_ID
, BATCH_ID BATCH_ID
, PRODUCT_ITEM_ID PRODUCT_ITEM_ID
, PROD_MATERIAL_DETAIL_ID PROD_MATERIAL_DETAIL_ID
, BATCHSTEP_ID BATCHSTEP_ID
, INGREDIENT_ITEM_ID INGREDIENT_ITEM_ID
, ING_MATERIAL_DETAIL_ID ING_MATERIAL_DETAIL_ID
, RESOURCES RESOURCES
, BATCHSTEP_RESOURCE_ID BATCHSTEP_RESOURCE_ID
, DERIVED_COST_ALLOC DERIVED_COST_ALLOC
, REQUIRED_DOC_QTY REQUIRED_DOC_QTY
, DELETE_MARK DELETE_MARK
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUIREMENT_ID REQUIREMENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, VIB_PROFILE_VALUE VIB_PROFILE_VALUE
FROM "GMF"."GMF_BATCH_REQUIREMENTS"