DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on INV_CONVERT

Line 145: (select max((case when (inv_convert.inv_um_convert(0,wor.uom_code,l_hrUOM) = -99999)

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)
146: then 0
147: else inv_convert.inv_um_convert(0,wor.uom_code,l_hrUOM)*wor.usage_rate_or_amount
148: end)*decode(wor.basis_type,WIP_CONSTANTS.PER_LOT,1,wo.scheduled_quantity)
149: /least(wor.assigned_units,bdr.capacity_units)/(nvl( bdr.utilization,1))/(nvl(bdr.efficiency,1))) lead_time

Line 147: else inv_convert.inv_um_convert(0,wor.uom_code,l_hrUOM)*wor.usage_rate_or_amount

143: into l_lead_time
144: from
145: (select max((case when (inv_convert.inv_um_convert(0,wor.uom_code,l_hrUOM) = -99999)
146: then 0
147: else inv_convert.inv_um_convert(0,wor.uom_code,l_hrUOM)*wor.usage_rate_or_amount
148: end)*decode(wor.basis_type,WIP_CONSTANTS.PER_LOT,1,wo.scheduled_quantity)
149: /least(wor.assigned_units,bdr.capacity_units)/(nvl( bdr.utilization,1))/(nvl(bdr.efficiency,1))) lead_time
150: from wip_operation_resources wor,
151: wip_operations wo,