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 3102: from wip_operations

3098:
3099: -- Get Department Id
3100: select department_id
3101: into l_department_id
3102: from wip_operations
3103: where wip_entity_id = l_wip_entity_id
3104: and operation_seq_num = p_operation_seq_num
3105: and organization_id = p_organization_id;
3106:

Line 4034: -- Procedure to update operations in wip_operations

4030: ROLLBACK TO label_insert_into_wo; -- Fix for 3582756
4031:
4032: END insert_into_wo;
4033: --------------------------------------------------------------------------
4034: -- Procedure to update operations in wip_operations
4035: -- Used in Operations Page
4036: -- Author : rethakur
4037: --------------------------------------------------------------------------
4038: procedure update_wo ( p_wip_entity_id IN NUMBER

Line 4260: wip_operations

4256: l_from_scheduled_start_date,
4257: l_from_scheduled_end_date,
4258: l_from_operation_completed
4259: from
4260: wip_operations
4261: where
4262: wip_entity_id = p_wip_entity_id and
4263: operation_seq_num = p_from_operation ;
4264: Exception

Line 4281: wip_operations

4277: l_to_scheduled_start_date,
4278: l_to_scheduled_end_date,
4279: l_to_operation_completed
4280: from
4281: wip_operations
4282: where
4283: wip_entity_id = p_wip_entity_id and
4284: operation_seq_num = p_to_operation ;
4285: Exception

Line 4326: update wip_operations

4322: x_error_flag := FND_API.G_RET_STS_ERROR;
4323: x_error_mssg := 'EAM_SCHEDULED_DATE_CHANGE';
4324: return;
4325: elsif(l_restrict_date_change = 0) then
4326: update wip_operations
4327: set
4328: first_unit_start_date = p_sche_start_date,
4329: last_unit_start_date = p_sche_start_date,
4330: first_unit_completion_date = p_sche_end_date,

Line 4371: update wip_operations

4367: x_error_flag := FND_API.G_RET_STS_ERROR;
4368: x_error_mssg := 'EAM_SCHEDULED_DATE_CHANGE';
4369: return;
4370: elsif(l_restrict_date_change = 0) then
4371: update wip_operations
4372: set
4373: first_unit_start_date = p_sche_start_date,
4374: last_unit_start_date = p_sche_start_date,
4375: first_unit_completion_date = p_sche_end_date,

Line 4808: FROM wip_operations

4804: BEGIN
4805:
4806: SELECT count(operation_seq_num)
4807: INTO l_op_count
4808: FROM wip_operations
4809: WHERE wip_entity_id = p_wip_entity_id and
4810: organization_id = p_organization_id;
4811: op_count := l_op_count;
4812:

Line 4816: FROM wip_operations wo, bom_departments bd

4812:
4813: if (l_op_count = 1 ) then
4814: SELECT wo.operation_seq_num, bd.department_code
4815: INTO op_seq_num, op_dept_code
4816: FROM wip_operations wo, bom_departments bd
4817: WHERE wo.wip_entity_id = p_wip_entity_id and
4818: wo.organization_id = p_organization_id and
4819: wo.organization_id = bd.organization_id and
4820: wo.department_id = bd.department_id;

Line 4848: FROM wip_operations

4844: BEGIN
4845:
4846: SELECT count(operation_seq_num)
4847: INTO l_op_count
4848: FROM wip_operations
4849: WHERE wip_entity_id = p_wip_entity_id and
4850: organization_id = p_organization_id;
4851: x_op_count := l_op_count;
4852:

Line 4856: FROM wip_operations wo, bom_departments bd

4852:
4853: if (l_op_count = 1 ) then
4854: SELECT wo.operation_seq_num, wo.first_unit_start_date, wo.last_unit_completion_date, bd.department_code
4855: INTO x_op_seq_num, x_op_start_date, x_op_end_date, x_op_dept_code
4856: FROM wip_operations wo, bom_departments bd
4857: WHERE wo.wip_entity_id = p_wip_entity_id and
4858: wo.organization_id = p_organization_id and
4859: wo.organization_id = bd.organization_id and
4860: wo.department_id = bd.department_id;

Line 4964: from wip_operations

4960:
4961: begin
4962: select operation_completed
4963: into l_completed
4964: from wip_operations
4965: where wip_entity_id = l_wip_entity_id
4966: and operation_seq_num = l_operation_seq_num;
4967: exception
4968: when others then