View: MSC_CO_PRODUCTS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	Thus view shows all the co-products
Implementation/DBA Data:	APPS.MSC_CO_PRODUCTS_V

View Text

SELECT MB.ROWID
, MB.PLAN_ID
, MB.SR_INSTANCE_ID
, MB.ASSEMBLY_ITEM_ID
, MBC.INVENTORY_ITEM_ID
, MB.ORGANIZATION_ID
, MSC_GET_NAME.ITEM_NAME(MBC.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL)
, (MBC.USAGE_QUANTITY)*-100
, MB.CREATED_BY
, MB.CREATION_DATE
, MB.LAST_UPDATED_BY
, MB.LAST_UPDATE_DATE
, MB.LAST_UPDATE_LOGIN
, MB.ATTRIBUTE_CATEGORY
, MB.ATTRIBUTE1
, MB.ATTRIBUTE2
, MB.ATTRIBUTE3
, MB.ATTRIBUTE4
, MB.ATTRIBUTE5
, MB.ATTRIBUTE6
, MB.ATTRIBUTE7
, MB.ATTRIBUTE8
, MB.ATTRIBUTE9
, MB.ATTRIBUTE10
, MB.ATTRIBUTE11
, MB.ATTRIBUTE12
, MB.ATTRIBUTE13
, MB.ATTRIBUTE14
FROM MSC_BOMS MB
, MSC_BOM_COMPONENTS MBC
WHERE MB.BILL_SEQUENCE_ID = MBC.BILL_SEQUENCE_ID
AND MBC.COMPONENT_TYPE = 10
AND MB.PLAN_ID = MBC.PLAN_ID
AND MB.ORGANIZATION_ID = MBC.ORGANIZATION_ID
AND MB.SR_INSTANCE_ID = MBC.SR_INSTANCE_ID

Columns