APPS.EAM_COPY_BOM_PKG dependencies on MTL_SYSTEM_ITEMS

Line 167: FROM mtl_system_items msi,

163: l_material_req_table(i).required_quantity := p_bom_table(l_index).component_quantity;
164:
165: -- strt Bug 14539580
166: SELECT msi.effectivity_control into l_effectivity_control
167: FROM mtl_system_items msi,
168: wip_discrete_jobs wdj
169: WHERE msi.inventory_item_id = nvl(wdj.asset_group_id,wdj.rebuild_item_id)
170: AND msi.organization_id = wdj.organization_id
171: AND wdj.wip_entity_id=p_wip_entity_id

Line 208: FROM mtl_system_items_vl

204: /*populating unit price for non stock items*/
205: BEGIN
206: SELECT LIST_PRICE_PER_UNIT
207: INTO l_material_req_table(i).unit_price
208: FROM mtl_system_items_vl
209: WHERE inventory_item_id=p_bom_table(l_index).component_item_id
210: AND stock_enabled_flag='N'
211: AND organization_id = p_organization_id;
212: EXCEPTION