APPS.CSP_PARTS_REQUIREMENT dependencies on MTL_SYSTEM_ITEMS

Line 45: From MTL_SYSTEM_ITEMS

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

Line 1906: FROM mtl_system_items

1902: l_line_rec := l_line_tbl(I);
1903: IF (l_line_rec.unit_of_measure IS NULL) THEN
1904: SELECT primary_uom_code
1905: INTO l_line_rec.unit_of_measure
1906: FROM mtl_system_items
1907: WHERE inventory_item_id = l_line_Rec.inventory_item_id
1908: AND organization_id = cs_Std.get_item_valdn_orgzn_id;
1909: END IF;
1910: l_rqmt_line_Rec.requirement_line_id := l_line_rec.requirement_line_id;