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_REQUIREMENT_OPERATIONS

Line 2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv

2614: begin
2615:
2616: select 1, wro.operation_seq_num,wro.department_id,msikfv.description
2617: into l_material_exists, l_existing_operation, l_existing_department, l_existing_description
2618: from wip_requirement_operations wro, mtl_system_items_kfv msikfv
2619: where wro.inventory_item_id = l_inventory_item_id
2620: and wro.organization_id = p_organization_id
2621: and wro.wip_entity_id = p_wip_entity_id
2622: and wro.organization_id = msikfv.organization_id

Line 2785: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new

2781: end if;
2782:
2783: ELSE
2784:
2785: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new
2786: -- entry into WIP_REQUIREMENT_OPERATIONS
2787:
2788: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2789: l_eam_mat_req_rec.wip_entity_id := p_wip_entity_id;

Line 2786: -- entry into WIP_REQUIREMENT_OPERATIONS

2782:
2783: ELSE
2784:
2785: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new
2786: -- entry into WIP_REQUIREMENT_OPERATIONS
2787:
2788: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
2789: l_eam_mat_req_rec.wip_entity_id := p_wip_entity_id;
2790: l_eam_mat_req_rec.organization_id := p_organization_id;

Line 3086: from wip_requirement_operations wro, mtl_system_items_kfv msikfv

3082: begin
3083:
3084: select 1, wro.operation_seq_num,wro.department_id,msikfv.description
3085: into l_material_exists, l_existing_operation, l_existing_department, l_existing_description
3086: from wip_requirement_operations wro, mtl_system_items_kfv msikfv
3087: where wro.inventory_item_id = l_inventory_item_id
3088: and wro.organization_id = p_organization_id
3089: and wro.wip_entity_id = p_wip_entity_id
3090: and wro.organization_id = msikfv.organization_id

Line 3275: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new

3271: end if;
3272:
3273: ELSE
3274:
3275: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new
3276: -- entry into WIP_REQUIREMENT_OPERATIONS
3277:
3278: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3279: l_eam_mat_req_rec.wip_entity_id := p_wip_entity_id;

Line 3276: -- entry into WIP_REQUIREMENT_OPERATIONS

3272:
3273: ELSE
3274:
3275: -- If entry does not exists in WIP_REQUIREMENT_OPERATIONS then place a new
3276: -- entry into WIP_REQUIREMENT_OPERATIONS
3277:
3278: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
3279: l_eam_mat_req_rec.wip_entity_id := p_wip_entity_id;
3280: l_eam_mat_req_rec.organization_id := p_organization_id;

Line 4944: from wip_requirement_operations

4940: where wip_entity_id = l_wip_entity_id and ( prior_operation = p_operation_seq_num or next_operation = p_operation_seq_num);
4941:
4942: select count(*)
4943: into l_count_mat
4944: from wip_requirement_operations
4945: where wip_entity_id = l_wip_entity_id
4946: and operation_seq_num = l_operation_seq_num;
4947:
4948: select count(*)