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.RCV_RETURN_SV dependencies on WIP_OPERATIONS

Line 346: wip_operations wn,

342: x_department_code
343: from wip_entities we,
344: bom_departments bd,
345: wip_operation_resources wr,
346: wip_operations wn,
347: wip_operations wo
348: where wo.wip_entity_id = x_wip_entity_id
349: and wo.organization_id = x_organization_id
350: and nvl(wo.repetitive_schedule_id, -1) =

Line 347: wip_operations wo

343: from wip_entities we,
344: bom_departments bd,
345: wip_operation_resources wr,
346: wip_operations wn,
347: wip_operations wo
348: where wo.wip_entity_id = x_wip_entity_id
349: and wo.organization_id = x_organization_id
350: and nvl(wo.repetitive_schedule_id, -1) =
351: nvl(x_wip_repetitive_schd_id,-1)

Line 395: wip_operations wn,

391: bd.department_code department
392: INTO x_operation_seq_num, x_department_code
393: FROM bom_departments bd,
394: wip_operation_resources wr,
395: wip_operations wn,
396: wip_operations wo
397: WHERE wo.wip_entity_id = x_wip_entity_id
398: AND wo.organization_id = x_organization_id
399: AND nvl(wo.repetitive_schedule_id, -1) =

Line 396: wip_operations wo

392: INTO x_operation_seq_num, x_department_code
393: FROM bom_departments bd,
394: wip_operation_resources wr,
395: wip_operations wn,
396: wip_operations wo
397: WHERE wo.wip_entity_id = x_wip_entity_id
398: AND wo.organization_id = x_organization_id
399: AND nvl(wo.repetitive_schedule_id, -1) =
400: nvl(x_wip_repetitive_schd_id, -1)

Line 425: from bom_departments bd,wip_operations wn

421: x_progress := 84;
422: begin
423: select bd.department_code department
424: into X_department_code
425: from bom_departments bd,wip_operations wn
426: where wn.wip_entity_id = x_wip_entity_id
427: and wn.organization_id = x_organization_id
428: and nvl(wn.repetitive_schedule_id, -1) =
429: nvl(x_wip_repetitive_schd_id, -1)

Line 440: FROM wip_operations wo

436:
437: begin
438: SELECT wo.operation_seq_num sequence
439: INTO x_operation_seq_num
440: FROM wip_operations wo
441: WHERE wo.wip_entity_id = x_wip_entity_id
442: AND wo.organization_id = x_organization_id
443: AND nvl(wo.repetitive_schedule_id, -1) =
444: nvl(x_wip_repetitive_schd_id, -1)