APPS.WIP_EAM_WORKREQUEST_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1020: FROM mtl_system_items_b_kfv

1016: FROM dual;
1017: IF (l_old_asset_group_id IS NOT NULL) THEN
1018: BEGIN
1019: SELECT concatenated_segments INTO l_old_data
1020: FROM mtl_system_items_b_kfv
1021: WHERE organization_id = p_org_id
1022: AND inventory_item_id = l_old_asset_group_id;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN

Line 1033: FROM mtl_system_items_b_kfv

1029: END IF;
1030: IF (l_new_asset_group_id IS NOT NULL) THEN
1031: BEGIN
1032: SELECT concatenated_segments INTO l_new_data
1033: FROM mtl_system_items_b_kfv
1034: WHERE organization_id = p_org_id
1035: AND inventory_item_id = l_new_asset_group_id;
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN

Line 2661: FROM csi_item_instances cii, mtl_system_items msi

2657: -- check that the asset is maintainable
2658:
2659: SELECT nvl(cii.maintainable_flag, 'Y'), cii.serial_number, msi.eam_item_type
2660: INTO l_dummy_char, l_asset_number,l_dummy_val
2661: FROM csi_item_instances cii, mtl_system_items msi
2662: WHERE cii.instance_id = p_maintenance_object_id AND
2663: cii.last_vld_organization_id = msi.organization_id AND
2664: cii.inventory_item_id = msi.inventory_item_id ;
2665:

Line 2694: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI

2690: -- check that the asset is maintainable
2691: -- Bug # 3553217.
2692: SELECT nvl(cii.maintainable_flag, 'Y'), eam_item_type
2693: INTO l_dummy_char, l_dummy_val
2694: FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MSI
2695: WHERE cii.serial_number = p_asset_number AND
2696: cii.inventory_item_id = p_asset_group_id AND
2697: cii.last_vld_organization_id = msi.organization_id AND
2698: cii.inventory_item_id = msi.inventory_item_id ;

Line 2960: from mtl_system_items

2956: IF p_asset_group_id is not null then
2957: begin
2958: select eam_item_type
2959: into l_eam_item_type
2960: from mtl_system_items
2961: where inventory_item_id = p_asset_group_id
2962: and organization_id = p_org_id;
2963: exception
2964: when no_data_found then