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

Line 30: FROM wip_operation_networks won, wip_operations wo

26: BEGIN
27: x_return_stat := 1;
28: -- Bug 3133704
29: SELECT count(operation_completed) into l_op_complete_count
30: FROM wip_operation_networks won, wip_operations wo
31: WHERE won.wip_entity_id = p_wip_entity_id
32: AND won.next_operation = p_operation_sequence_number
33: AND won.organization_id = p_organization_id
34: AND wo.wip_entity_id = p_wip_entity_id

Line 65: from wip_operations where

61:
62: BEGIN
63: select operation_completed
64: into l_complete_yn
65: from wip_operations where
66: wip_entity_id = p_wip_entity_id and
67: operation_seq_num = p_operation_sequence_number and
68: organization_id = p_organization_id;
69:

Line 100: from wip_operations where

96: x_return_stat := 1;
97:
98: select operation_completed
99: into l_cur_completed_yn
100: from wip_operations where
101: wip_entity_id = p_wip_entity_id and
102: operation_seq_num = p_operation_sequence_number and
103: organization_id = p_organization_id;
104:

Line 114: l_completed_yn from wip_operations where

110: prior_operation = p_operation_sequence_number and
111: organization_id = p_organization_id) LOOP
112:
113: SELECT operation_completed INTO
114: l_completed_yn from wip_operations where
115: wip_entity_id = p_wip_entity_id and
116: operation_seq_num = cur_operation_record.next_operation and
117: organization_id = p_organization_id;
118:

Line 133: l_completed_yn from wip_operations where

129: next_operation = p_operation_sequence_number and
130: organization_id = p_organization_id) LOOP
131:
132: SELECT operation_completed INTO
133: l_completed_yn from wip_operations where
134: wip_entity_id = p_wip_entity_id and
135: operation_seq_num = cur_operation_record.prior_operation and
136: organization_id = p_organization_id;
137:

Line 259: FROM wip_operations

255: -- using last_update_date as indicator
256: BEGIN
257: SELECT last_update_date, operation_completed, shutdown_type
258: INTO l_db_last_update_date, l_db_status, l_shutdown_type
259: FROM wip_operations
260: WHERE wip_entity_id = p_wip_entity_id
261: and operation_seq_num = p_operation_seq_num
262: FOR UPDATE;
263:

Line 535: TYPE OpCurType IS REF CURSOR RETURN wip_operations%ROWTYPE;

531: l_old_dept_id NUMBER;
532: l_transaction_id number;
533: l_old_op_duration number;
534: l_new_op_completion_date date;
535: TYPE OpCurType IS REF CURSOR RETURN wip_operations%ROWTYPE;
536: opCur OpCurType;
537: opRow wip_operations%ROWTYPE;
538:
539: /* added for calling WO API */

Line 537: opRow wip_operations%ROWTYPE;

533: l_old_op_duration number;
534: l_new_op_completion_date date;
535: TYPE OpCurType IS REF CURSOR RETURN wip_operations%ROWTYPE;
536: opCur OpCurType;
537: opRow wip_operations%ROWTYPE;
538:
539: /* added for calling WO API */
540:
541: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;

Line 623: FROM wip_operations

619: ,l_actual_start_date
620: ,l_actual_end_date
621: ,l_org_id
622: ,l_old_dept_id
623: FROM wip_operations
624: WHERE
625: wip_entity_id = p_wip_entity_id
626: and operation_seq_num = p_old_op_seq_num
627: FOR UPDATE;

Line 647: into l_count from wip_operations

643: END IF;
644:
645:
646: select count(*)
647: into l_count from wip_operations
648: where wip_entity_id = p_wip_entity_id and operation_seq_num = p_new_op_seq_num;
649: IF( l_count > 0 ) THEN
650: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_OP_EXISTED');
651: x_return_status := FND_API.G_RET_STS_ERROR;

Line 702: from wip_operations

698:
699: -- keep the data before complete the op, use it to create new op
700: select *
701: into opRow
702: from wip_operations
703: where wip_entity_id = p_wip_entity_id
704: and operation_seq_num = p_old_op_seq_num;
705:
706: if l_actual_start_date <= sysdate then --added by akalaval for bug 4162307

Line 1039: FROM wip_operations

1035: operation_completed
1036: INTO
1037: l_actual_end_date,
1038: l_completed
1039: FROM wip_operations
1040: WHERE
1041: wip_entity_id = p_wip_entity_id
1042: AND operation_seq_num = nxtOpCurVar.prior_operation;
1043:

Line 1144: FROM wip_operations

1140: ,first_unit_start_date
1141: INTO
1142: l_completed
1143: ,l_actual_start_date
1144: FROM wip_operations
1145: WHERE
1146: wip_entity_id = p_wip_entity_id
1147: AND operation_seq_num = prvOpCurVar.next_operation;
1148:

Line 1368: from wip_operations

1364: -- Validate the new operation
1365: begin
1366: select operation_seq_num
1367: into l_new_op_seq_num
1368: from wip_operations
1369: where wip_entity_id = p_wip_entity_id
1370: and operation_seq_num = p_new_op_seq_num;
1371: Exception when others then
1372: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_HANDOVER_OP_NOTFOUND');

Line 1789: from wip_operations

1785: and res.unit_of_measure = muc.uom_code
1786: and muc.inventory_item_id = 0
1787: and res.organization_id = p_organization_id
1788: and department_id = (select department_id
1789: from wip_operations
1790: where wip_entity_id = p_wip_entity_id
1791: and operation_seq_num = p_operation_seq_num);
1792:
1793:

Line 1797: from wip_operations wo, bom_departments bd

1793:
1794:
1795: CURSOR c_oper_cur IS --rhshriva
1796: select wo.operation_seq_num, bd.department_code
1797: from wip_operations wo, bom_departments bd
1798: where bd.department_id = wo.department_id
1799: and bd.organization_id = wo.organization_id
1800: and wo.organization_id = p_organization_id
1801: and wo.wip_entity_id = p_wip_entity_id;

Line 2634: from wip_operations

2630:
2631: -- Get Department Id
2632: select department_id
2633: into l_department_id
2634: from wip_operations
2635: where wip_entity_id = l_wip_entity_id
2636: and operation_seq_num = p_operation_seq_num
2637: and organization_id = p_organization_id;
2638:

Line 3524: -- Procedure to update operations in wip_operations

3520: ROLLBACK TO label_insert_into_wo; -- Fix for 3582756
3521:
3522: END insert_into_wo;
3523: --------------------------------------------------------------------------
3524: -- Procedure to update operations in wip_operations
3525: -- Used in Operations Page
3526: -- Author : rethakur
3527: --------------------------------------------------------------------------
3528: procedure update_wo ( p_wip_entity_id IN NUMBER

Line 3750: wip_operations

3746: l_from_scheduled_start_date,
3747: l_from_scheduled_end_date,
3748: l_from_operation_completed
3749: from
3750: wip_operations
3751: where
3752: wip_entity_id = p_wip_entity_id and
3753: operation_seq_num = p_from_operation ;
3754: Exception

Line 3771: wip_operations

3767: l_to_scheduled_start_date,
3768: l_to_scheduled_end_date,
3769: l_to_operation_completed
3770: from
3771: wip_operations
3772: where
3773: wip_entity_id = p_wip_entity_id and
3774: operation_seq_num = p_to_operation ;
3775: Exception

Line 3816: update wip_operations

3812: x_error_flag := FND_API.G_RET_STS_ERROR;
3813: x_error_mssg := 'EAM_SCHEDULED_DATE_CHANGE';
3814: return;
3815: elsif(l_restrict_date_change = 0) then
3816: update wip_operations
3817: set
3818: first_unit_start_date = p_sche_start_date,
3819: last_unit_start_date = p_sche_start_date,
3820: first_unit_completion_date = p_sche_end_date,

Line 3861: update wip_operations

3857: x_error_flag := FND_API.G_RET_STS_ERROR;
3858: x_error_mssg := 'EAM_SCHEDULED_DATE_CHANGE';
3859: return;
3860: elsif(l_restrict_date_change = 0) then
3861: update wip_operations
3862: set
3863: first_unit_start_date = p_sche_start_date,
3864: last_unit_start_date = p_sche_start_date,
3865: first_unit_completion_date = p_sche_end_date,

Line 4298: FROM wip_operations

4294: BEGIN
4295:
4296: SELECT count(operation_seq_num)
4297: INTO l_op_count
4298: FROM wip_operations
4299: WHERE wip_entity_id = p_wip_entity_id and
4300: organization_id = p_organization_id;
4301: op_count := l_op_count;
4302:

Line 4306: FROM wip_operations wo, bom_departments bd

4302:
4303: if (l_op_count = 1 ) then
4304: SELECT wo.operation_seq_num, bd.department_code
4305: INTO op_seq_num, op_dept_code
4306: FROM wip_operations wo, bom_departments bd
4307: WHERE wo.wip_entity_id = p_wip_entity_id and
4308: wo.organization_id = p_organization_id and
4309: wo.organization_id = bd.organization_id and
4310: wo.department_id = bd.department_id;

Line 4338: FROM wip_operations

4334: BEGIN
4335:
4336: SELECT count(operation_seq_num)
4337: INTO l_op_count
4338: FROM wip_operations
4339: WHERE wip_entity_id = p_wip_entity_id and
4340: organization_id = p_organization_id;
4341: x_op_count := l_op_count;
4342:

Line 4346: FROM wip_operations wo, bom_departments bd

4342:
4343: if (l_op_count = 1 ) then
4344: SELECT wo.operation_seq_num, wo.first_unit_start_date, wo.last_unit_completion_date, bd.department_code
4345: INTO x_op_seq_num, x_op_start_date, x_op_end_date, x_op_dept_code
4346: FROM wip_operations wo, bom_departments bd
4347: WHERE wo.wip_entity_id = p_wip_entity_id and
4348: wo.organization_id = p_organization_id and
4349: wo.organization_id = bd.organization_id and
4350: wo.department_id = bd.department_id;

Line 4454: from wip_operations

4450:
4451: begin
4452: select operation_completed
4453: into l_completed
4454: from wip_operations
4455: where wip_entity_id = l_wip_entity_id
4456: and operation_seq_num = l_operation_seq_num;
4457: exception
4458: when others then