DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on WIP_OPERATIONS

Line 151: wip_operations wo,

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,
152: bom_department_resources bdr,
153: bom_resources br
154: where wo.wip_entity_id = p_wip_entity_id
155: and wo.wip_entity_id = wor.wip_entity_id