DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on FND_PROFILE

Line 141: l_hrUOM := fnd_profile.value('BOM:HOUR_UOM_CODE');

137: l_hrUOM varchar2(3);
138: l_lead_time number;
139: begin
140:
141: l_hrUOM := fnd_profile.value('BOM:HOUR_UOM_CODE');
142: select sum(lead_time)
143: into l_lead_time
144: from
145: (select max((case when (inv_convert.inv_um_convert(0,wor.uom_code,l_hrUOM) = -99999)