VIEW: APPS.MSC_CO_PRODUCTS_V

Source

View Text - Preformatted

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), msc_get_name.item_desc(mbc.inventory_item_id, mbc.organization_id, mbc.plan_id, mbc.sr_instance_id), (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

View Text - HTML Formatted

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)
, MSC_GET_NAME.ITEM_DESC(MBC.INVENTORY_ITEM_ID
, MBC.ORGANIZATION_ID
, MBC.PLAN_ID
, MBC.SR_INSTANCE_ID)
, (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