eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WS_PTPKPI_UTIL dependencies on WIP_CONSTANTS

Line 148: end)*decode(wor.basis_type,WIP_CONSTANTS.PER_LOT,1,wo.scheduled_quantity)

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,
152: bom_department_resources bdr,

Line 161: and br.resource_type in (WIP_CONSTANTS.RES_MACHINE, WIP_CONSTANTS.RES_PERSON)

157: and wo.operation_seq_num = wor.operation_seq_num
158: and wo.department_id = bdr.department_id
159: and wor.resource_id = bdr.resource_id
160: and wor.resource_id = br.resource_id
161: and br.resource_type in (WIP_CONSTANTS.RES_MACHINE, WIP_CONSTANTS.RES_PERSON)
162: and wor.scheduled_flag <> WIP_CONSTANTS.SCHED_NO
163: group by to_char(nvl(to_char(wor.schedule_seq_num),rowidtochar(wor.rowid)))
164: );
165:

Line 162: and wor.scheduled_flag <> WIP_CONSTANTS.SCHED_NO

158: and wo.department_id = bdr.department_id
159: and wor.resource_id = bdr.resource_id
160: and wor.resource_id = br.resource_id
161: and br.resource_type in (WIP_CONSTANTS.RES_MACHINE, WIP_CONSTANTS.RES_PERSON)
162: and wor.scheduled_flag <> WIP_CONSTANTS.SCHED_NO
163: group by to_char(nvl(to_char(wor.schedule_seq_num),rowidtochar(wor.rowid)))
164: );
165:
166: return l_lead_time;