APPS.WIP_WS_PTPKPI_UTIL dependencies on BOM_DEPARTMENT_RESOURCES

Line 152: bom_department_resources bdr,

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
156: and wo.operation_seq_num = p_op_seq_num