VIEW: MSC.MSC_BOM_BOD_INTERFACE#

Source

View Text - Preformatted

select BOM_BOD_ID BOM_BOD_ID, PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, PARTY_ID PARTY_ID, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME, ASSEMBLY_ITEM_UOM ASSEMBLY_ITEM_UOM, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, INVENTORY_ITEM_UOM INVENTORY_ITEM_UOM, USAGE_QUANTITY USAGE_QUANTITY, BOM_EFFECTIVITY_DATE BOM_EFFECTIVITY_DATE, BOM_DISABLE_DATE BOM_DISABLE_DATE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, AVG_TRANSIT_LEAD_TIME AVG_TRANSIT_LEAD_TIME, SOURCING_EFFECTIVITY_DATE SOURCING_EFFECTIVITY_DATE, SOURCING_DISABLE_DATE SOURCING_DISABLE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ROW_STATUS ROW_STATUS, ERROR_MSG ERROR_MSG, BATCH_ID BATCH_ID from "MSC"."MSC_BOM_BOD_INTERFACE"

View Text - HTML Formatted

SELECT BOM_BOD_ID BOM_BOD_ID
, PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, PARTY_ID PARTY_ID
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, ASSEMBLY_ITEM_NAME ASSEMBLY_ITEM_NAME
, ASSEMBLY_ITEM_UOM ASSEMBLY_ITEM_UOM
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, INVENTORY_ITEM_UOM INVENTORY_ITEM_UOM
, USAGE_QUANTITY USAGE_QUANTITY
, BOM_EFFECTIVITY_DATE BOM_EFFECTIVITY_DATE
, BOM_DISABLE_DATE BOM_DISABLE_DATE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, AVG_TRANSIT_LEAD_TIME AVG_TRANSIT_LEAD_TIME
, SOURCING_EFFECTIVITY_DATE SOURCING_EFFECTIVITY_DATE
, SOURCING_DISABLE_DATE SOURCING_DISABLE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ROW_STATUS ROW_STATUS
, ERROR_MSG ERROR_MSG
, BATCH_ID BATCH_ID
FROM "MSC"."MSC_BOM_BOD_INTERFACE"