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_UPDATE_SETUP_RESOURCES dependencies on WIP_OPERATION_RESOURCES

Line 21: from wip_operation_resources wor

17: and organization_id = p_organization_id
18: and operation_seq_num = p_operation_seq_num
19: and resource_seq_num in (
20: select resource_seq_num
21: from wip_operation_resources wor
22: where wor.wip_entity_id = p_wip_entity_id
23: and wor.organization_id = p_organization_id
24: and wor.operation_seq_num = p_operation_seq_num
25: and wor.parent_resource_seq = p_resource_seq_num);

Line 28: delete from wip_operation_resources

24: and wor.operation_seq_num = p_operation_seq_num
25: and wor.parent_resource_seq = p_resource_seq_num);
26:
27: -- delete old setup resources
28: delete from wip_operation_resources
29: where wip_entity_id = p_wip_entity_id
30: and organization_id = p_organization_id
31: and operation_seq_num = p_operation_seq_num
32: and parent_resource_seq = p_resource_seq_num;

Line 99: from wip_operation_resources wor,

95: wor.resource_seq_num resource_seq_num,
96: wor.setup_id,
97: nvl(wo.quantity_running,0)+nvl(wo.quantity_completed,0) processed_qty,
98: wor.start_date start_date
99: from wip_operation_resources wor,
100: wip_operations wo
101: where wor.start_date >= p_completion_date
102: and wor.resource_id = p_resource_id
103: and wor.parent_resource_seq is null

Line 134: wip_operation_resources wor1,

130: wor1.setup_id,
131: nvl(wo.quantity_running,0)+nvl(wo.quantity_completed,0) processed_qty,
132: wor1.start_date start_date
133: from wip_op_resource_instances wori1,
134: wip_operation_resources wor1,
135: wip_operations wo
136: where wor1.wip_entity_id = wori1.wip_entity_id
137: and wor1.operation_seq_num = wori1.operation_seq_num
138: and wor1.resource_seq_num = wori1.resource_seq_num

Line 207: from wip_operation_resources wor,

203: into l_setup_id,
204: l_resource_id,
205: l_dept_id,
206: l_res_completion_date
207: from wip_operation_resources wor,
208: wip_operations wo
209: where wor.wip_entity_id = p_wip_entity_id
210: and wor.organization_id = p_organization_id
211: and wor.operation_seq_num = p_operation_seq

Line 278: from wip_operation_resources

274: -- get the max resource sequence for the operation
275: select max(res)
276: into l_setup_op_res_seq
277: from (select max(resource_seq_num) res
278: from wip_operation_resources
279: where wip_entity_id = l_next_wip_entity_id
280: and operation_seq_num = l_next_operation_seq_num
281: union
282: select max(resource_seq_num) res

Line 290: INSERT INTO WIP_OPERATION_RESOURCES

286:
287: l_setup_op_res_seq := l_setup_op_res_seq+10;
288:
289: -- insert setup resource for the resource that is being setup
290: INSERT INTO WIP_OPERATION_RESOURCES
291: (last_update_date,
292: last_updated_by,
293: creation_date,
294: created_by,

Line 348: wip_operation_resources wor

344: wor.substitute_group_num,
345: wor.replacement_group_num,
346: wor.schedule_seq_num
347: FROM
348: wip_operation_resources wor
349: WHERE wor.wip_entity_id = l_next_wip_entity_id
350: and wor.organization_id = p_organization_id
351: and wor.operation_seq_num = l_next_operation_seq_num
352: and wor.resource_seq_num = l_next_resource_seq_num;

Line 382: from wip_operation_resources

378: FND_GLOBAL.USER_ID,
379: SYSDATE,
380: FND_GLOBAL.USER_ID,
381: LAST_UPDATE_LOGIN
382: from wip_operation_resources
383: where wip_entity_id = l_next_wip_entity_id
384: and organization_id = p_organization_id
385: and operation_seq_num = l_next_operation_seq_num
386: and resource_seq_num = l_setup_op_res_seq;

Line 392: INSERT INTO WIP_OPERATION_RESOURCES

388: FOR setup_res_rec in setup_resource_cursor(l_std_op_id) LOOP
389:
390: l_setup_op_res_seq := l_setup_op_res_seq+10;
391:
392: INSERT INTO WIP_OPERATION_RESOURCES
393: (last_update_date,
394: last_updated_by,
395: creation_date,
396: created_by,

Line 452: wip_operation_resources wor

448: wor.substitute_group_num,
449: wor.replacement_group_num,
450: wor.schedule_seq_num
451: FROM
452: wip_operation_resources wor
453: where wor.wip_entity_id = l_next_wip_entity_id
454: and wor.organization_id = p_organization_id
455: and wor.operation_seq_num = l_next_operation_seq_num
456: and wor.resource_seq_num = l_next_resource_seq_num;

Line 495: from wip_operation_resources

491: FND_GLOBAL.USER_ID,
492: SYSDATE,
493: FND_GLOBAL.USER_ID,
494: LAST_UPDATE_LOGIN
495: from wip_operation_resources
496: where wip_entity_id = l_next_wip_entity_id
497: and organization_id = p_organization_id
498: and operation_seq_num = l_next_operation_seq_num
499: and resource_seq_num = l_setup_op_res_seq

Line 542: from wip_operation_resources wor

538: IS
539: CURSOR OPERATION_RESOURCES_CURS(p_wip_entity_id NUMBER) IS
540: select wor.operation_seq_num,
541: wor.resource_seq_num
542: from wip_operation_resources wor
543: where wor.wip_entity_id = p_wip_entity_id;
544:
545:
546: BEGIN

Line 590: from wip_operation_resources wor

586: where wori.wip_entity_id = p_wip_entity_id
587: and wori.organization_id = p_organization_id
588: and wori.resource_seq_num in (
589: select resource_seq_num
590: from wip_operation_resources wor
591: where wor.wip_entity_id = p_wip_entity_id
592: and wor.organization_id = p_organization_id
593: and wor.parent_resource_seq is not null);
594:

Line 596: delete from wip_operation_resources

592: and wor.organization_id = p_organization_id
593: and wor.parent_resource_seq is not null);
594:
595: -- delete old setup resources
596: delete from wip_operation_resources
597: where wip_entity_id = p_wip_entity_id
598: and organization_id = p_organization_id
599: and parent_resource_seq is not null;
600: