APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 333: /* cursor to get records from wip_resource_actual_times for calculating AAH */

329: and brs.shift_num= bcs.shift_num
330: and brs.department_id = dept_id
331: and brs.resource_id = res_id;
332:
333: /* cursor to get records from wip_resource_actual_times for calculating AAH */
334: cursor aah_records(org_id number,
335: emp_id number,
336: start_time date,
337: end_time date) is

Line 341: from wip_resource_actual_times

337: end_time date) is
338: select start_date as actual_date,
339: decode(action_flag,2,-duration,duration) as duration,
340: uom_code
341: from wip_resource_actual_times
342: where organization_id = org_id
343: and employee_id = emp_id
344: and wip_entity_id is null
345: and time_entry_mode in (6,8)

Line 349: /* cursor to get records from wip_resource_actual_times for calculating SAH */

345: and time_entry_mode in (6,8)
346: and start_date between start_time and end_time
347: and duration is not null;
348:
349: /* cursor to get records from wip_resource_actual_times for calculating SAH */
350: cursor sah_records(org_id number,
351: emp_id number,
352: start_time date,
353: end_time date) is

Line 357: from wip_resource_actual_times

353: end_time date) is
354: select start_date as actual_date,
355: decode(action_flag,2,-duration,duration) as duration,
356: uom_code
357: from wip_resource_actual_times
358: where organization_id = org_id
359: and employee_id = emp_id
360: and wip_entity_id is null
361: and time_entry_mode =7

Line 365: /* cursor to get all records from wip_resource_actual_times for calculating DLH */

361: and time_entry_mode =7
362: and start_date between start_time and end_time
363: and duration is not null;
364:
365: /* cursor to get all records from wip_resource_actual_times for calculating DLH */
366: -- Lot based jobs also uses wip_resource_actual_times. So added condition on entity_type.
367: cursor dlh_records(org_id number,
368: dept_id number,
369: res_id number,

Line 366: -- Lot based jobs also uses wip_resource_actual_times. So added condition on entity_type.

362: and start_date between start_time and end_time
363: and duration is not null;
364:
365: /* cursor to get all records from wip_resource_actual_times for calculating DLH */
366: -- Lot based jobs also uses wip_resource_actual_times. So added condition on entity_type.
367: cursor dlh_records(org_id number,
368: dept_id number,
369: res_id number,
370: emp_id number,

Line 376: from wip_resource_actual_times wrat,

372: end_time date) is
373: select wrat.start_date as actual_date,
374: decode(wrat.action_flag,2,-wrat.duration,wrat.duration) as duration,
375: wrat.uom_code
376: from wip_resource_actual_times wrat,
377: wip_operations wo,
378: wip_entities we
379: where wrat.organization_id = org_id
380: and wrat.organization_id= wo.organization_id

Line 403: from wip_resource_actual_times wrat,

399: end_time date) is
400: select distinct wrat.wip_entity_id as wip_entity_id,
401: wrat.operation_seq_num as operation_seq_num,
402: get_index_for_date(wrat.start_date,wrat.organization_id,wo.department_id,res_id) as emp_index
403: from wip_resource_actual_times wrat,
404: wip_operations wo,
405: wip_entities we
406: where wrat.organization_id = org_id
407: and wrat.organization_id= wo.organization_id