APPS.EAM_PROCESS_WO_PUB dependencies on WIP_ENTITIES

Line 1498: from wip_entities

1494: end if;
1495: l_eam_wo_list.delete;
1496: --Insert the error message.
1497: select wip_entity_name into l_wo_name
1498: from wip_entities
1499: where wip_entity_id = l_temp_wip_entity_id;
1500:
1501: eam_execution_jsp.add_message(p_app_short_name => 'EAM',
1502: p_msg_name => 'EAM_WO_CHK_DATES_ERR',

Line 4496: SELECT ORGANIZATION_ID INTO l_organization_id from wip_entities where wip_entity_id = l_wip_entity_id;

4492: --check for work order/permit association for existing permit
4493:
4494: IF p_eam_permit_wo_assoc_tbl.COUNT > 0 THEN
4495:
4496: SELECT ORGANIZATION_ID INTO l_organization_id from wip_entities where wip_entity_id = l_wip_entity_id;
4497: i :=1;
4498:
4499: FOR j in p_eam_permit_wo_assoc_tbl.FIRST..p_eam_permit_wo_assoc_tbl.LAST LOOP
4500:

Line 5942: update wip_entities

5938: update wip_discrete_jobs
5939: set primary_item_id = l_old_activity_id
5940: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id;
5941:
5942: update wip_entities
5943: set primary_item_id = l_old_activity_id
5944: where wip_entity_id = l_out_eam_wo_rec.wip_entity_id; /*added for bug 9974953*/
5945:
5946: update wip_operations wo

Line 6280: wip_entities we

6276:
6277: SELECT count(*) as count
6278: FROM
6279: po_requisition_lines_all pr,
6280: wip_entities we
6281: WHERE
6282: pr.destination_organization_id = p_organization_id
6283: AND pr.item_id is null
6284: AND pr.wip_resource_seq_num = x_direct_item_sequence_id

Line 6296: wip_entities we

6292: SELECT count(*) as count
6293: FROM
6294: po_distributions_all pd,
6295: po_lines_all pl,
6296: wip_entities we
6297: WHERE
6298: pd.destination_organization_id = p_organization_id
6299: AND pd.po_line_id = pl.po_line_id(+)
6300: AND pl.item_id is null