[Home] [Help] [Dependency Information]
Object Name: | MSC_BOM_BOD_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOM_BOD_ID | NUMBER | |||
PLAN_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
PARTY_ID | NUMBER | |||
ASSEMBLY_ITEM_ID | NUMBER | |||
ASSEMBLY_ITEM_NAME | VARCHAR2 | (250) | Yes | |
ASSEMBLY_ITEM_UOM | VARCHAR2 | (3) | Yes | |
INVENTORY_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_NAME | VARCHAR2 | (250) | Yes | |
INVENTORY_ITEM_UOM | VARCHAR2 | (3) | Yes | |
USAGE_QUANTITY | NUMBER | Yes | ||
BOM_EFFECTIVITY_DATE | DATE | |||
BOM_DISABLE_DATE | DATE | |||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_NAME | VARCHAR2 | (255) | ||
AVG_TRANSIT_LEAD_TIME | NUMBER | |||
SOURCING_EFFECTIVITY_DATE | DATE | |||
SOURCING_DISABLE_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
ROW_STATUS | NUMBER | |||
ERROR_MSG | VARCHAR2 | (240) | ||
BATCH_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BOM_BOD_ID
, PLAN_ID
, SR_INSTANCE_ID
, PARTY_ID
, ASSEMBLY_ITEM_ID
, ASSEMBLY_ITEM_NAME
, ASSEMBLY_ITEM_UOM
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NAME
, INVENTORY_ITEM_UOM
, USAGE_QUANTITY
, BOM_EFFECTIVITY_DATE
, BOM_DISABLE_DATE
, SUPPLIER_ID
, SUPPLIER_NAME
, AVG_TRANSIT_LEAD_TIME
, SOURCING_EFFECTIVITY_DATE
, SOURCING_DISABLE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, ROW_STATUS
, ERROR_MSG
, BATCH_ID
FROM MSC.MSC_BOM_BOD_INTERFACE#;
|
|
|