APPS.MSD_DEM_COLLECT_BOM_DATA dependencies on MSC_SYSTEM_ITEMS

Line 74: FROM msc_system_items

70: p_sr_inventory_item_pk IN VARCHAR2)
71: IS
72: CURSOR c1 IS
73: SELECT bom_item_type
74: FROM msc_system_items
75: WHERE sr_instance_id = p_instance
76: AND organization_id = p_sr_org_pk
77: AND inventory_item_id = p_sr_inventory_item_pk
78: AND plan_id = -1;

Line 159: FROM msc_system_items msi,

155: (mbc.usage_quantity * mbc.Component_Yield_Factor),
156: (mbc.usage_quantity / mbc.Component_Yield_Factor))
157: * msd_dem_common_utilities.uom_conv(msi.sr_instance_id, msi.uom_code,msi.sr_inventory_item_id) usage_quantity,
158: mbc.disable_date disable_date
159: FROM msc_system_items msi,
160: msc_bom_components mbc
161: WHERE msi.plan_id = -1
162: AND msi.sr_instance_id = p_instance
163: AND msi.organization_id = p_sr_org_pk

Line 285: msc_system_items assemble,

281: mb.bill_sequence_id,
282: mbc.optional_component
283: FROM msc_boms mb,
284: msc_bom_components mbc,
285: msc_system_items assemble,
286: msc_system_items ascp_comp
287: WHERE mb.plan_id = -1
288: AND mb.sr_instance_id = p_sr_instance_id
289: AND decode (p_master_org, null, mb.organization_id, p_master_org) = mb.organization_id

Line 286: msc_system_items ascp_comp

282: mbc.optional_component
283: FROM msc_boms mb,
284: msc_bom_components mbc,
285: msc_system_items assemble,
286: msc_system_items ascp_comp
287: WHERE mb.plan_id = -1
288: AND mb.sr_instance_id = p_sr_instance_id
289: AND decode (p_master_org, null, mb.organization_id, p_master_org) = mb.organization_id
290: AND mb.alternate_bom_designator is null

Line 323: FROM msc_system_items

319: CURSOR c2(p_instance IN NUMBER,
320: p_org_id IN NUMBER,
321: p_item_id IN NUMBER) IS
322: SELECT sr_inventory_item_id
323: FROM msc_system_items
324: WHERE sr_instance_id = p_instance
325: AND plan_id = -1
326: AND organization_id = p_org_id
327: AND inventory_item_id = p_item_id;