APPS.MSD_BOM_COLLECTIONS dependencies on MSC_SYSTEM_ITEMS

Line 135: msc_system_items assemble,

131: mb.bill_sequence_id,
132: mbc.optional_component
133: FROM msc_bom_components mbc,
134: msc_boms mb,
135: msc_system_items assemble,
136: msc_system_items ascp_comp
137: WHERE mbc.plan_id = -1
138: AND mb.plan_id = mbc.plan_id
139: AND ascp_comp.plan_id = mbc.plan_id

Line 136: msc_system_items ascp_comp

132: mbc.optional_component
133: FROM msc_bom_components mbc,
134: msc_boms mb,
135: msc_system_items assemble,
136: msc_system_items ascp_comp
137: WHERE mbc.plan_id = -1
138: AND mb.plan_id = mbc.plan_id
139: AND ascp_comp.plan_id = mbc.plan_id
140: AND mb.organization_id = mbc.organization_id

Line 166: from msc_system_items

162: cursor c2(p_instance in number,
163: p_org_id in number,
164: p_item_id in number) is
165: select sr_inventory_item_id
166: from msc_system_items
167: where sr_instance_id = p_instance
168: and plan_id = -1
169: and organization_id = p_org_id
170: and inventory_item_id = p_item_id;

Line 472: FROM msc_system_items

468: p_sr_inventory_item_pk in varchar2) is
469:
470: CURSOR C1 IS
471: SELECT bom_item_type
472: FROM msc_system_items
473: WHERE sr_instance_id = p_instance
474: AND organization_id = p_sr_org_pk
475: AND inventory_item_id = p_sr_inventory_item_pk
476: AND plan_id = -1;

Line 550: msc_system_items msi

546: abs(mbc.usage_quantity)),
547: 1, (mbc.usage_quantity * mbc.Component_Yield_Factor),
548: (mbc.usage_quantity / mbc.Component_Yield_Factor))*msd_sr_util.uom_conv(msi.uom_code,msi.sr_inventory_item_id) usage_quantity
549: from msc_bom_components mbc,
550: msc_system_items msi
551: where mbc.plan_id = -1
552: and msi.plan_id = -1
553: and msi.organization_id = mbc.organization_id
554: and msi.sr_instance_id = p_instance