DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on WIP_ENTITIES

Line 3207: SELECT wip_entity_name INTO l_wip_entity_name FROM wip_entities WHERE wip_entity_id=l_eam_mat_req_rec.wip_entity_id;

3203: --Start bug# 11672256
3204: SELECT segment1 INTO l_inv_item_name FROM mtl_system_items WHERE inventory_item_id=l_eam_mat_req_rec.inventory_item_id AND organization_id=l_eam_mat_req_rec.organization_id;
3205: l_other_token_tbl(1).token_name := 'INV_ITEM_NAME';
3206: l_other_token_tbl(1).token_value := l_inv_item_name;
3207: SELECT wip_entity_name INTO l_wip_entity_name FROM wip_entities WHERE wip_entity_id=l_eam_mat_req_rec.wip_entity_id;
3208: l_other_token_tbl(2).token_name := 'WIP_ENTITY_NAME';
3209: l_other_token_tbl(2).token_value := l_wip_entity_name;
3210: -- End bug# 11672256
3211: RAISE EXC_SEV_QUIT_BRANCH;

Line 10781: FROM WIP_ENTITIES we

10777: l_token_tbl(1).token_name := 'WorkOrder';
10778: -- l_token_tbl(1).token_value := l_eam_wo_rec.wip_entity_id;
10779:
10780: SELECT wip_entity_name into l_token_tbl(1).token_value
10781: FROM WIP_ENTITIES we
10782: WHERE we.wip_entity_id = l_eam_wo_rec.wip_entity_id
10783: AND we.organization_id = l_eam_wo_rec.organization_id;
10784:
10785:

Line 10864: FROM WIP_ENTITIES we

10860: l_token_tbl(1).token_name := 'WorkOrder';
10861: -- l_token_tbl(1).token_value := l_eam_wo_rec.wip_entity_id;
10862:
10863: SELECT wip_entity_name into l_token_tbl(1).token_value
10864: FROM WIP_ENTITIES we
10865: WHERE we.wip_entity_id = l_eam_wo_rec.wip_entity_id
10866: AND we.organization_id = l_eam_wo_rec.organization_id;
10867:
10868:

Line 11737: FROM wip_entities

11733: x_return_status := FND_API.G_RET_STS_SUCCESS;
11734: l_eam_wo_comp_rec := p_eam_wo_comp_rec;
11735:
11736: SELECT wip_entity_name INTO l_wip_entity_name
11737: FROM wip_entities
11738: WHERE wip_entity_id = l_eam_wo_comp_rec.wip_entity_id;
11739:
11740: l_org_id := l_eam_wo_comp_rec.organization_id;
11741: l_wip_entity_id := l_eam_wo_comp_rec.wip_entity_id;

Line 12973: FROM wip_entities

12969: l_org_id := l_eam_op_comp_rec.organization_id;
12970: l_wip_entity_id := l_eam_op_comp_rec.wip_entity_id;
12971:
12972: SELECT wip_entity_name INTO l_wip_entity_name
12973: FROM wip_entities
12974: WHERE wip_entity_id = l_eam_op_comp_rec.wip_entity_id;
12975:
12976: SELECT nvl(wdj.asset_group_id,wdj.rebuild_item_id),
12977: nvl(wdj.asset_number,wdj.rebuild_serial_number),