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 338: wip_operations wn,

334: x_department_code
335: from wip_entities we,
336: bom_departments bd,
337: wip_operation_resources wr,
338: wip_operations wn,
339: wip_operations wo
340: where wo.wip_entity_id = x_wip_entity_id
341: and wo.organization_id = x_organization_id
342: and nvl(wo.repetitive_schedule_id, -1) =

Line 339: wip_operations wo

335: from wip_entities we,
336: bom_departments bd,
337: wip_operation_resources wr,
338: wip_operations wn,
339: wip_operations wo
340: where wo.wip_entity_id = x_wip_entity_id
341: and wo.organization_id = x_organization_id
342: and nvl(wo.repetitive_schedule_id, -1) =
343: nvl(x_wip_repetitive_schd_id,-1)

Line 387: wip_operations wn,

383: bd.department_code department
384: INTO x_operation_seq_num, x_department_code
385: FROM bom_departments bd,
386: wip_operation_resources wr,
387: wip_operations wn,
388: wip_operations wo
389: WHERE wo.wip_entity_id = x_wip_entity_id
390: AND wo.organization_id = x_organization_id
391: AND nvl(wo.repetitive_schedule_id, -1) =

Line 388: wip_operations wo

384: INTO x_operation_seq_num, x_department_code
385: FROM bom_departments bd,
386: wip_operation_resources wr,
387: wip_operations wn,
388: wip_operations wo
389: WHERE wo.wip_entity_id = x_wip_entity_id
390: AND wo.organization_id = x_organization_id
391: AND nvl(wo.repetitive_schedule_id, -1) =
392: nvl(x_wip_repetitive_schd_id, -1)

Line 417: from bom_departments bd,wip_operations wn

413: x_progress := 84;
414: begin
415: select bd.department_code department
416: into X_department_code
417: from bom_departments bd,wip_operations wn
418: where wn.wip_entity_id = x_wip_entity_id
419: and wn.organization_id = x_organization_id
420: and nvl(wn.repetitive_schedule_id, -1) =
421: nvl(x_wip_repetitive_schd_id, -1)

Line 432: FROM wip_operations wo

428:
429: begin
430: SELECT wo.operation_seq_num sequence
431: INTO x_operation_seq_num
432: FROM wip_operations wo
433: WHERE wo.wip_entity_id = x_wip_entity_id
434: AND wo.organization_id = x_organization_id
435: AND nvl(wo.repetitive_schedule_id, -1) =
436: nvl(x_wip_repetitive_schd_id, -1)