APPS.CSP_PARTS_REQUIREMENT dependencies on MTL_SYSTEM_ITEMS

Line 43: From MTL_SYSTEM_ITEMS

39: Cursor c_Get_Source_Item(p_inventory_item_id Number,p_org_id Number) Is
40: Select SOURCE_TYPE,
41: SOURCE_ORGANIZATION_ID,
42: SOURCE_SUBINVENTORY
43: From MTL_SYSTEM_ITEMS
44: Where INVENTORY_ITEM_ID = p_inventory_item_id
45: And ORGANIZATION_ID = p_org_id;
46:
47: Cursor c_Get_Source_Item_Subinv(p_inventory_item_id Number,p_org_id Number,p_subinventory Varchar2) Is

Line 1790: FROM mtl_system_items

1786: l_line_rec := l_line_tbl(I);
1787: IF (l_line_rec.unit_of_measure IS NULL) THEN
1788: SELECT primary_uom_code
1789: INTO l_line_rec.unit_of_measure
1790: FROM mtl_system_items
1791: WHERE inventory_item_id = l_line_Rec.inventory_item_id
1792: AND organization_id = cs_Std.get_item_valdn_orgzn_id;
1793: END IF;
1794: l_rqmt_line_Rec.requirement_line_id := l_line_rec.requirement_line_id;