22: --Kris make a global variable for validation org so we don't have to get it all the time
23:
24: /*l_validation_org_id := fnd_profile.value('OE_ORGANIZATION_ID');*/
25: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
26: l_validation_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID', p_org_id);
27:
28: SELECT concatenated_segments
29: INTO l_inventory_item
30: FROM MTL_SYSTEM_ITEMS_kfv