APPS.CS_COST_DETAILS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 477: FROM mtl_system_items_b

473: ) RETURN VARCHAR2 IS
474:
475: CURSOR c_inventory_item_id IS
476: SELECT 1
477: FROM mtl_system_items_b
478: WHERE organization_id =cs_std.get_item_valdn_orgzn_id -- modified by bkanimoz on 21-jan-2007
479: AND inventory_item_id =p_inventory_item_id;
480:
481: lv_exists_flag VARCHAR2(1) := 'N';

Line 578: FROM mtl_system_items_b msi,

574: ) IS
575:
576: CURSOR c_primary_uom(p_inv_id IN NUMBER) IS
577: SELECT mum.uom_code
578: FROM mtl_system_items_b msi,
579: mtl_units_of_measure_tl mum
580: WHERE msi.primary_unit_of_measure = mum.unit_of_measure
581: AND msi.inventory_item_id = p_inventory_item_id
582: AND msi.organization_id = p_org_id;